View Full Version : Pgsql General



  1. About update
  2. About update
  3. Strange plpgsql performance -- arithmetic, numeric() type, arrays
  4. plpgsql -- any '+' ,'-' operators for INET?
  5. Re: PostgreSQL and .NET
  6. How to query pgsql from a BASH script ?
  7. what's the best in 8.0
  8. Re: Recovering real disk space
  9. How many clients can one database server handle
  10. Re: Recovering real disk space
  11. Re: Debugging deadlocks
  12. Re: Recovering real disk space
  13. Re: How to copy from Table to table
  14. Re: Recovering real disk space
  15. Re: general purpose full text indexing
  16. Re: join error?
  17. Re: Crazy Multiplication Issue
  18. Re: getting information of tables and indexes
  19. Re: getting information of tables and indexes
  20. test
  21. varbit functions
  22. Loosing connection with the database
  23. Re: plPHP in core?
  24. Insert without duplicates
  25. case sensitive group by
  26. Re: [ANNOUNCE] == PostgreSQL Weekly News - April 01 2005 ==
  27. diskspace usage recovered on db rebuild
  28. Re: Help with converting hexadecimal to decimal
  29. Inheritance and such
  30. Best practices for (plpgsql ?) trigger optimization?
  31. [Fwd: [webmaster] in Search of free hosting with PostgreSQL]
  32. Tracing Backend process
  33. Re: : Postgres order by into a RECORD, not ordering
  34. inherited type
  35. Re: : Postgres order by into a RECORD, not ordering
  36. Re: : Postgres order by into a RECORD, not ordering
  37. Re: Help with order by into a RECORD
  38. Re: Help with order by into a RECORD
  39. FW: Help with order by into a RECORD
  40. Re: : Postgres IX
  41. PL/PERL with composite return values & PGSQL 7.4?
  42. : Postgres IX
  43. importance of bgwriter_percent
  44. Re: not able to connect to Database
  45. SELECT INTO Array?
  46. Inconsistent values for 'now'
  47. logging prepared queries' arguments?
  48. table permissions
  49. Re: your thoughts on a crazy idea please
  50. Re: Debugging deadlocks
  51. Help with converting hexadecimal to decimal
  52. your thoughts on a crazy idea please
  53. getGeneratedKeys()
  54. Help with case in select
  55. Re: Temporary Tables
  56. Re: Temporary Tables
  57. Re: DNN Postgres Data Provider
  58. Re: Database monitor (again)
  59. DNN Postgres Data Provider
  60. plpgsql array initialization, what's the story?
  61. storing files in postgres
  62. Re: Temporary Tables
  63. Re: Temporary Tables
  64. Temporary Tables
  65. Re: truncate/create slowness
  66. How to identify long-running queries, not just long-running backends?
  67. Postgres PL SQL bug?
  68. truncate/create slowness
  69. not able to connect to Database
  70. Re: Catch of ERROR in PLPGSQL
  71. Re: plperl doesn't release memory
  72. Re: Catch of ERROR in PLPGSQL
  73. Compriere or other ERP database dump for Postgres
  74. Re: plperl doesn't release memory
  75. Fw: Empty date
  76. Database monitor (again)
  77. Triggers: using table's primary key value to update another field
  78. database monitor
  79. Re: Database monitoring
  80. PostgreSQL and .NET
  81. Re: Days in month query
  82. Re: Days in month query
  83. Database monitoring
  84. Re: Days in month query
  85. Days in month query
  86. Re: [ODBC] delphi access question?
  87. Restore to a database with another name?
  88. Re: Is the FTP server down?
  89. Re: Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.
  90. what's wrong with postgres 8
  91. Catch of ERROR in PLPGSQL
  92. limited disk space
  93. Is the FTP server down?
  94. Re: Zombie processes
  95. Ayuda con procesamiento en Postgres !!!!
  96. libpq usage in Samba
  97. Postgres Processing Help !!!!
  98. Re: Zombie processes
  99. Re: Postgres plpgsql
  100. Re: plperl doesn't release memory
  101. Postgres plpgsql
  102. Drivers for Other Languages
  103. Re: Postgres mystery
  104. Postgres mystery
  105. Re: How to return a record and sets of record in plpython
  106. Re: Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.
  107. Re: Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.
  108. Re: Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.
  109. Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.
  110. database monitor
  111. Upgrade data
  112. Re: do I need replication or something else?
  113. Re: 8.0.1 in a non-standard location and tsearch2
  114. Re: do I need replication or something else?
  115. do I need replication or something else?
  116. Solaris 10 svc setup
  117. Re: after gentoo emerge plpython failure
  118. Zombie processes
  119. 8.0.2beta1
  120. 8.0.2beta1 RPMs
  121. Unable to restore table oids from pg_dump
  122. Views!
  123. unsubscribe
  124. after gentoo emerge plpython failure
  125. Error en la instalacion pgsql 8 en xp
  126. sub query constraint
  127. Re: Debugging deadlocks
  128. general purpose full text indexing
  129. Table partition for very large table
  130. Re: sorting Chinese varchar field
  131. sorting Chinese varchar field
  132. US DoD FOSS Recommendation
  133. pg_xlog disk full error, i need help
  134. about blob type
  135. Can't pg_dumpall, claims database exists twice
  136. Linux Filesystem for PG
  137. Parallel Query should be a top priority
  138. Tablespaces and indexes
  139. After Insert or Update Trigger Issues!
  140. Re: Debugging deadlocks
  141. Re: dblinks?
  142. dblinks?
  143. Clustering system tables
  144. Server load planning
  145. Re: PG constraint
  146. Re: create or replace trigger?
  147. major delays in list....
  148. Re: Command prompt window (8.0)
  149. Debugging deadlocks
  150. Re: create or replace trigger?
  151. LWM 2004 Readers' Choice Nomination
  152. Major Performance issue
  153. Perl and AutoCommit
  154. 8.0.2 Beta Available
  155. Problems building PostgreSQL 8.01 under Mandrake 10.1
  156. plpgsql no longer exists
  157. unsupported types in 8.0.1
  158. Re: Persistent data per connection
  159. TSearch2 FreeBSD
  160. help w/ a little naive brainstorming ...
  161. pg_index question
  162. Merging item codes using referential integrity
  163. syntax issue with custom aggregator
  164. Re: psql variables
  165. [ANNOUNCE] Manitou-Mail
  166. Referential integrity using constant in foreign key
  167. Persistent data per connection
  168. Stuck with references
  169. pl/perl problem of memory
  170. Re: sort array optimisation in pl/perl
  171. 8.0.1 in a non-standard location and tsearch2
  172. building 8.0.1 on OS X
  173. relid and relname
  174. Re: Converting from single user w/pool to multiple users
  175. Any easy ways to change configuration
  176. Re: Converting from single user w/pool to multiple users
  177. Re: Converting from single user w/pool to multiple users
  178. sort array optimisation in pl/perl
  179. budiling postgresql-8.0.1 on Linux with GCC 4
  180. Pgsql 8.0 on Win32 Production env.
  181. Re: Good Books
  182. How to get the size in bytes of a table data
  183. Converting from single user w/pool to multiple users
  184. Questions regarding interaction of stored functions andtransactions
  185. How to retrieve the comment for a constraint?
  186. Good Books
  187. Another help needed on Window client
  188. plperl doesn't release memory
  189. Re: postgres oracle emulation question
  190. tsearch2 installation question
  191. postgresql max memory (pl/Perl)
  192. debug_print_plan
  193. Re: postgres oracle emulation question
  194. Re: pl/perl problem
  195. Re: pl/perl problem
  196. Re: Simple query takes a long time on win2K
  197. Re: Command Prompt on Window version
  198. Existence of tuples in relations and a multicolumn index.
  199. Command Prompt on Window version
  200. Re: Simple query takes a long time on win2K
  201. Re: Simple query takes a long time on win2K
  202. backend process
  203. postgresql unicode lower/upper problem
  204. strange overlaps?
  205. Delay INSERT
  206. Re: PLPGSQL
  207. Table audit system
  208. FW: PLPGSQL
  209. PLPGSQL
  210. Extracting object source code from database to store in CVS...
  211. Re: Simple query takes a long time on win2K
  212. PostgreSQL support
  213. Simple query takes a long time on win2K
  214. ++ PLPGSQL
  215. PLPGSQL
  216. Re: PHP SQL
  217. Re: postgres oracle emulation question
  218. Re: postgres oracle emulation question
  219. inherited table and rules
  220. postgres oracle emulation question
  221. contrib module intagg crashing the backend
  222. checkpoint_timeout
  223. Changing constraints to deferrable
  224. OSX, ODBC and Office 2004
  225. failure with pg_dump
  226. Question about function body checking and 8.1
  227. Constraint problem
  228. Re: PHP SQL
  229. Version 1.0.0.19 of OLE DB released
  230. grant problem
  231. Exporting to XML
  232. PHP SQL
  233. Using rule with function for view delete gives error on OLD.* type
  234. Re: pl/perl problem
  235. multi line text data/query ?bug?
  236. Clearing locks
  237. Measuring Query Performance
  238. Re: Problem connecting to postmaster
  239. Problem connecting to postmaster
  240. Re: Tsearch vector not stored by update/set
  241. bit varying(512) vs bytea(64)
  242. how do I clear a page, or set an item in a page to 'free'?
  243. PostgreSQL users, tell your tale on Slashdot
  244. Re: psql variables
  245. Time Stamp
  246. pl/perl problem
  247. PostgreSQL v7.4.7 support platform?
  248. Test
  249. weird error on installing postgresql in Windows XP
  250. Re: no IF - am I missing something ?