PDA

View Full Version : Pgsql General

  1. Performance
  2. Vacuum DB in Postgres Vs similar concept in other RDBMS
  3. Tsearch2: upgrading from postgres 8.1.x to 8.2.x
  4. Re: OIDs - file objects, are damaged by PostgreSQL.
  5. Sequential scan from simple query
  6. deleting/dropping tables...
  7. Re: Several queries consume 100 % processor
  8. Faster data type for one-length values
  9. Re: Integrity on large sites
  10. Several queries consume 100 % processor
  11. Integrity on large sites
  12. Using a trigger with an object-relational manager
  13. SQL Manager 2007 for PostgreSQL released
  14. Command line export or copy utility?
  15. partial word matching
  16. autoReconnect with PostGres
  17. How to move tables in another physial place
  18. swap storm created by 8.2.3
  19. Rounding datetimes
  20. Permance issues with migrated db
  21. Problem with pg_dump
  22. default db
  23. Re: Postgresql 8.2.4 crash with tsearch2
  24. Re: Postgresql 8.2.4 crash with tsearch2
  25. initializing the database cluster
  26. Adding auto-increment / sequence
  27. Schema sanity check
  28. What is "Postgresql Hot"?
  29. feature suggestions
  30. Lock table, Select for update and Serialization error
  31. Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x
  32. Postgresql 8.2.4 crash with tsearch2
  33. Re: [HACKERS] Role members
  34. replace function in a query
  35. TSearch2 memory usage
  36. User permissions/Data separation.
  37. dump/restore and statistics
  38. doverlaps() returns null
  39. Trigger function which inserts into table; values from lookup
  40. Performance tuning?
  41. Against legal disclaimers in email
  42. Committing in a trigger
  43. adding missing FROM-clause entry for table
  44. tsearch2 keep throw-away characters
  45. about the pgadmin3
  46. Database corruption
  47. JDBC - Prepared statements and PostgreSql Time/Date operations
  48. Random Sample
  49. Creating a function if it's not there in Postgres
  50. contirb install
  51. Re: Large Database Restore
  52. Re: Large Database Restore
  53. Data replication through disk replication
  54. Location of \pgsql\src\test\regress\readme.
  55. Tools for dumping pg_xlog, pg_clog, etc?
  56. change database encoding without corrupting data (latin9 to utf8)
  57. how to return 0 rows in function
  58. (NONE)
  59. how to return 0 rows in function
  60. Postgres / Jaro Winkler fuzzy string matching
  61. Problem with inherited tables vs query planning
  62. Privs on deleted objects
  63. 8.0, UTF8, and CLIENT_ENCODING
  64. short ciruit logic of plpgsql in 8.2
  65. contrib
  66. Admin-Functions in Ubuntu's PG 8.2 missing?
  67. Installing contrib / fuzzystr
  68. UNION help
  69. Transaction commit in a trigger function
  70. New accec method
  71. FULL JOIN is only supported with merge-joinable join conditions
  72. Paypal and "going root"
  73. Memory settings, vm.overcommit, how to get it really safe?
  74. Large Database Restore
  75. Granting privileges on views to group roles
  76. Time Zone Error
  77. Windows Vista Support
  78. Vacuum non-clustered tables only
  79. Constructing a SELECT statement in pl/pgsql
  80. cube operations
  81. Capital One Bank Notification - Please Read - ID: COB495886838
  82. to_number behavior change between 8.1 and 8.2
  83. basic postgres questions...
  84. Plpgsql function and variable substitute
  85. Are foreign key's automatically set as indicies?
  86. Fixing broken permissions for deleted user
  87. Compile problems with contrib/xml in 7 series
  88. I have some problems while installing PostgreSQL
  89. stats collector spins my disk up every 500ms (8.2.3)
  90. dns less connection
  91. Recovering a messed-up database
  92. Restarting postgres server
  93. Performance issues of one vs. two split tables.
  94. a few questions on backup
  95. migrating a tablespace between postgres instances in shared diskenvironment
  96. Age function
  97. explain problem
  98. tsearch2 problem
  99. OID - file object, are damaged by PostgreSQL.
  100. primary key index
  101. EXCEPTION clause not identified
  102. Printing values on pgadmin tool window using plperlu
  103. Postgres Printed Manuals
  104. How to implement GOMONTH function
  105. How access table by tableoid
  106. Internals of PostgreSQL - Documentation or presentations
  107. Winsock error 10035 while trying to upgrade from 8.0 to 8.2
  108. autovacuum
  109. Partitioning on IS NULL / IS NOT NULL not supported?
  110. stuck on values in 8.2
  111. postgres upgrade
  112. TWO SAME TABLES, ONE UPDATED. HOW TO SYNC THE OTHER?
  113. Streaming large data into postgres [WORM like applications]
  114. Database transaction related
  115. UTF-8 to ASCII
  116. [Fwd: Re: backup and restore]
  117. Fault Tolerant Postgresql (two machines, two postmasters, one diskarray)
  118. schema of system tables
  119. table change
  120. Installation fails on windows vista
  121. xml to db converter
  122. Windows installation; why is PL/python shown but disabled?
  123. Pattern Matching - Range of Letters
  124. how to convert a string array to a string. fct array_to_string seemto work only for INT array??
  125. Invoke trigger after commit
  126. SQL Transaction related
  127. IP Address Validation
  128. Replication for PG 8 recommendations
  129. WAL file internals and why a 64 bit will not work on a 32 bit
  130. re Referential Integrity Flash Tutorial
  131. CentOS 5, pg8.4.2, could not read time zone file
  132. In theory question
  133. Problem with data corruption and psql memory usage
  134. Solaris Postgresql 8.1.8 vs Postgresql 8.2.4
  135. typical schema for a forum?
  136. backup and restore
  137. Views- Advantages and Disadvantages
  138. printing variable values in pl/pgsql functions
  139. Re: log shipping/DB recovery with PostgreSQL 7.4
  140. Pulling data from a filesystem level backup
  141. log shipping/DB recovery with PostgreSQL 7.4
  142. Server specs to run PostgreSQL
  143. PostgreSql embedded available?
  144. Issue with database Postgresql :(
  145. User restrictions
  146. Idle session timeout?
  147. Spliting a string in plpgsql
  148. npgsql and standard_conforming_strings
  149. Building Pg 8.2.4 on AIX 5.3 doesn't produce shared libs?
  150. PG on Debian 4.0.x ?
  151. Re: Continuous Archiving for Multiple Warm StandbyServers
  152. Re: Slow query and indexes...
  153. Re: Any "guide to indexes" exists?
  154. SELECT TIMESTAMP WITH TIME ZONE ... AT TIME ZOME as inverted meaning with UTC times...
  155. Re: Continuous Archiving for Multiple Warm Standby Servers
  156. Re: PITR and tar
  157. pg_contraint: 'action code' ?
  158. are foreign keys realized as indexes?
  159. /var/run/postgresql ??
  160. Re: PITR and tar
  161. Re: Postgre Sql 7.3 connection problem
  162. 'Expensive' column in result set
  163. Vacuuming
  164. tokenize string for tsearch?
  165. change the stop words file for tsearch2
  166. Re: Date Math
  167. Re: Slow query and indexes...
  168. Re: Any "guide to indexes" exists?
  169. JDBC - setting PG variables in URL
  170. Re: Date Math
  171. problem with a conditional statement
  172. Re: syntax error in "createdb"
  173. Buena documentacion
  174. Connections refused during backups
  175. did not find any relation for existing table
  176. shmget fails on OS X with proper settings
  177. Refreshing a warm spare with WAL files
  178. pg_ctl: could not start service "pgsql-8.2": error code 1063
  179. query not using index
  180. An alternatives to rules and triggers
  181. Casting to varchar
  182. DataArchitect Version 4.0 now available
  183. multi-language web application: is it possible?
  184. Permission denied to create database
  185. Query not using index despite high statistics
  186. Re: Postgres 8.3-dev
  187. Regarding autocomplete
  188. script for taking incremental backup in postgres in LINUX
  189. WAL
  190. Help tracking down error in postgres log
  191. Dangers of fsync = off
  192. Separating function privileges from tables
  193. Password authentication failed
  194. Indexing questions: Index == key? And index vs substring - how successful?
  195. varchar as primary key
  196. tuple concurrently updated
  197. psql access of user's environmental variables
  198. Cross-schema inheritence problem
  199. Update violating constraint
  200. C functions under windows
  201. forcing use of a specific (expression) index?
  202. Have I b0rked something? Slow comparisons on "where x in (...)"
  203. How to get comments for view columns?
  204. Utility of OIDs in postgres
  205. Postgres (selection of thesis topic)
  206. multidimensional arrays
  207. Dynamically Allocated System Resources
  208. CHECK() Constraint on Column Using Lookup Table
  209. PostgreSql replication and load balancing ( is Slony-I a solution?)
  210. STDERR vs. SYSLOG logging
  211. dump-restore only one table
  212. Re: [HACKERS] SOS, help me please, one problem towards the postgresql developement on windows
  213. PG Books
  214. IF function?
  215. pgsql and Mac OS X
  216. function and bytea
  217. Questions about TSearch2 and PG 8.2
  218. Server crash on postgresql 8.2.4 with tsearch2
  219. tsearch2 issue
  220. When the locially dropped column is also physically dropped
  221. Server crash on postgresql 8.2.4 with tsearch2
  222. Selecting from a function(x,y) returning a row-type(sum, prod)
  223. Stemming not working with tsearch2() function
  224. DRI in Docs?
  225. Temporal Units
  226. Re: "Protocol error. Session setup failed" (PostgreSQL8.3devel/postgresql-8.3dev-600.jdbc3)
  227. tsearch2 and english locale on Debian - english.0 english.1
  228. CONSTRAINT name With Domain As Check
  229. Re: Query in function not using index...
  230. Indice en Date
  231. postgres.exe - Entry point not found (PostgreSQL 8.3 devel)
  232. Store dates in database in different format
  233. Re: Store dates in database in different format
  234. Re: Store dates in database in different format
  235. Query in function not using index...
  236. Using a library compiled for 8.3 in 8.2
  237. Preferred Installation/Data Directories
  238. Converting time to float
  239. Some problem with warm standby server
  240. binary representation of date and numeric
  241. PostgreSQL upgrade server A -> server B
  242. Re: dropping role w/dependent objects
  243. Re: [NOVICE] column and table names
  244. Processing a work queue
  245. NFS vs. PostgreSQL on Solaris
  246. Compiling PostgreSQL 8.2 on Windows using msvc2k5
  247. "WARNING Bison install not found, or unsupported Bison version."
  248. DIfferent plans for explicit versus implicit join using link table
  249. Upgrade Process
  250. HP/Pgsql/DBD::Pg issue