PDA

View Full Version : Pgsql General

  1. Re: running a query file of 42MB
  2. running a query file of 42MB
  3. Long-running performance (MVCC, Vacuum, etc.) - Any fix?
  4. error : syntax error at or near $1 for over select rows
  5. 8.0 Beta3 worked, RC1 didn't!
  6. Re: Get current trasanction id
  7. Where is the error
  8. 8.0 rc2 Problem
  9. Merry Christmas
  10. Re: [sfpug] Basic problem installing TSearch2 (full text
  11. Re: default index for primary key of a table
  12. win32 installer problem
  13. Re: 8.0 Beta3 worked, RC1 didn't!
  14. loading only few rows from huge table
  15. Making a varchar bigger
  16. Caching/Indexing Function Output
  17. update table with row locking
  18. Re: monitoring tools
  19. select as
  20. 8.0 Beta3 worked, RC1 didn't!
  21. Re: monitoring tools
  22. Re: monitoring tools
  23. monitoring tools
  24. Re: bytea
  25. Very slow stored proc
  26. Basic problem installing TSearch2 (full text search)
  27. Re: migrating from mysql
  28. migrating from mysql
  29. converting unique index into primary key
  30. duplicate msgs when delivery through commandprompt.com
  31. Memory Errors OS X
  32. Re: 8.0 Beta3 worked, RC1 didn't!
  33. Re: Strange Index behavior
  34. Re: nice work on the new site
  35. AREs in substring(from)
  36. valid using INITIALLY DEFERRED
  37. postgresql.conf
  38. Re: PostgreSQL training curriculum
  39. Strange Index behavior
  40. default index created for primary key
  41. SQL query question
  42. Problem with Select output
  43. Re: 8.0 Beta3 worked, RC1 didn't!
  44. replicator
  45. PostgreSQL 8.0.0 Release Candidate 2
  46. 8.0 Beta3 worked, RC1 didn't!
  47. ANNOUNCE: DBD::Pg 1.40 release candidate 1 request for testing
  48. tool for incrementally shrinking bloated tables
  49. PostgreSQL training curriculum
  50. New Fedora 3 install gives: relation "pg_catalog.pg_user" does notexist
  51. Problem with database
  52. ISO_8859_8 encoding
  53. DELETE versus TRUNCATE during pg_dump....
  54. RES: RES: NewsForge Poll: Favorite open source database?
  55. RES: NewsForge Poll: Favorite open source database?
  56. Create a cache DB between web portal and internal DB?
  57. Need help to organize database
  58. transactions in multiple action rules
  59. problems with date
  60. weird run-times with pg_autovacuum
  61. Installing postgres 8 using Remote Desktop Connection
  62. Short circuit operations in plpgsql?
  63. Re: Scheduler in Postgres
  64. Problems with pg_restore
  65. Diskspace
  66. Re: RES: NewsForge Poll: Favorite open source database?
  67. Re: readline configure error again
  68. pgjob registered on pgFoundary
  69. Israel Go-Linux conference
  70. A "cascade on delete" constraints deletes AFTER the source is gone??
  71. PG8 final when
  72. could not access file $libdir...
  73. Make a query faster...
  74. could not read block 84253 of relation "tablename": Input/outputerror
  75. Re: Connect to Postgres 7.4 via ODBC SOLVED!!!!!
  76. BTree max row size?
  77. Multi row sequence?
  78. NewsForge Poll: Favorite open source database?
  79. Contacting Tom Lane :)
  80. Re: Scheduler in Postgres
  81. Re: Check if table exists
  82. MD5(MD5(pw)) OK?
  83. unix_socket_directory
  84. Re: analyze-error: "cannot compare arrays of different element types" revisited
  85. Re: analyze-error: "cannot compare arrays of different element types" revisited
  86. replacements for vacuum?
  87. OSX 10.3.7 broke Postgresql 8.0.0b5?
  88. unsubscribe pgsql-general
  89. unsubscribe pgsql-general
  90. (NONE)
  91. Problem with pl/perl in postgresql 8.0rc1
  92. Re: Trigger: what rows were deleted?
  93. Trigger: what rows were deleted?
  94. Debian PLPython
  95. sorting problem
  96. MD5
  97. tsearch2 avoiding firing of triggers.....
  98. Non-aggregate values attached to aggregates?
  99. Re: pl/pgsql oddity
  100. Re: pl/pgsql oddity
  101. Re: pl/pgsql oddity
  102. 7.1.3: dataloss: FATAL 2: XLogFlush: request is not satisfied
  103. What HW / OS is recommeded
  104. DB Slowing Down
  105. Serial column has suddenly stopped working
  106. Pattern matching a line ending character... Please ignore previousmessage, solved!
  107. Pattern matching a line ending character
  108. online backup in critical systems
  109. pl/pgsql oddity
  110. Aggregates not allowed in WHERE clause?
  111. bytea internal encoding
  112. Debian Packages for Postgresql 8.0.0 RC1
  113. Re: Can a database notify all clients when something changes?
  114. Can a database notify all clients when something changes?
  115. Insert do not work in my case
  116. UNION with more restrictive DISTINCT
  117. is there a repair utility for postgresql?
  118. could not create semaphores : No space left on device = FreeBSD port install error!
  119. Completely transparent casts
  120. G5 compiler optimizations
  121. transactions, functions, foreign keys
  122. pgplsql SELECT INTO ... FOR UPDATE (transaction/locking question)
  123. Running functions that return void in psql
  124. pgEdit 1.0b5
  125. Connect to Postgres 7.4 via ODBC
  126. java.sql.SQLException: ERROR: Relation 38868974 does not exist
  127. Re: Copy row from table to table
  128. Unable to read data from the transport connection.
  129. catching script errors in PSQL and redirecting to file?
  130. Re: Corrupt RTREE index
  131. query or schema question
  132. VACUUM FULL [ANALYZE] problem
  133. Which (table) lock mode to use
  134. Re: Corrupt RTREE index
  135. Re: Performance suggestions?
  136. Performance suggestions?
  137. Re: Performance differences 7.1 to 7.3
  138. WAL/pg_xlog on Another Disk: Redundancy?
  139. 4th RFD: comp.databases.postgresql
  140. Re: Best practice in postgres
  141. Re: Corrupt RTREE index
  142. Deadlock detected during vacuum analyze
  143. Copy row from table to table
  144. Re: Sheduler in Postgres
  145. Cannot drop template1
  146. WG: AW: Index on geometry and timestamp
  147. Insufficient memory for this operation.
  148. Help needed with QueryPlan
  149. Multiple foreign keys on same field
  150. Re: Performance differences 7.1 to 7.3
  151. Performance differences 7.1 to 7.3
  152. Possible dump/restore bug
  153. Corrupt RTREE index
  154. Re: subscribe missing?
  155. plperl loading
  156. Re: disabling OIDs?
  157. Re: subscribe missing?
  158. Substring question
  159. partial index on boolean, problem with v8.0.0rc1
  160. Re: disabling OIDs?
  161. subscribe missing?
  162. "Complex" data types like BYTEA in embedded SQL with ecpg
  163. Re: High volume inserts - more disks or more CPUs?
  164. index not used in joins
  165. High volume inserts - more disks or more CPUs?
  166. Re: problem in connecting to postgreserver
  167. disabling OIDs?
  168. problem in connecting to postgreserver
  169. Re: Best practice in postgres
  170. Re: Index scan vs. Seq scan on timestamps
  171. Re: using postgresql functions from php
  172. Re: ERROR: relation "table" does not exist - HELP
  173. Re: relation "sql_features" does not exist
  174. Re: vacuumdb
  175. Re: question: how to preload data and excute table creation scripts
  176. Re: Select after insert to the unique column
  177. Re: question: how to preload data and excute table creation scripts
  178. Re: When to encrypt
  179. Regarding Postgres installation and administration on linux suse 9.0
  180. Best practice in postgres
  181. Re: Simple function
  182. Clustering in the presence of hierarchies (fwd)
  183. Checking inequality
  184. Re: Install pgsql directory
  185. PREPARED STATEMENT
  186. Re: ERROR: relation "table" does not exist - HELP
  187. Re: postgresql and javascript
  188. Re: signal 4 recieved when index creation
  189. Re: Natural ordering in postgresql? Does it exist?
  190. Re: Performance tuning on RedHat Enterprise Linux 3
  191. Re: gborg.postgresql.org
  192. trouble with on insert rule via libpg-perl
  193. Re: trouble with on insert rule via libpg-perl
  194. Re: Sheduler in Postgres
  195. What's faster
  196. using inheritance in production application.
  197. Ridiculous load
  198. information schema extra fields
  199. Re: Performance
  200. Re: migrating from informix
  201. Re: migrating from informix
  202. Query is not using index when it should
  203. Problems with JDBC site and Postgres mailing list subscription page
  204. Spanning tables
  205. Strange NOTICE: messages in log file
  206. Re: postgresql and javascript
  207. table with sort_key without gaps
  208. Temporary tables and disk activity
  209. test
  210. Mailing List Problems?
  211. Postgres 8 and Slony-1
  212. any body able to access news.postgresql.org recently?
  213. test
  214. No mailing list posts
  215. Loading data from tab delimited file using COPY
  216. Re: postgresql and javascript
  217. Problem with Insert rules: using nextval: get schema *new* does notexist and other oddities
  218. Re: When to encrypt
  219. Problems with information_schema
  220. Clustering in the presence of hierarchies
  221. Re: postgresql and javascript
  222. Re: postgresql and javascript
  223. Re: Sheduler in Postgres
  224. Questions on stored-procedure best practices
  225. Re: postgresql and javascript
  226. Natural ordering in postgresql? Does it exist?
  227. How to get rid of notices for create table?
  228. Re: migrating from informix
  229. Join on virtual table
  230. Re: Create AS question
  231. Significado logo PostgreSQL
  232. Servers live ... news at 11 ...
  233. Postgres 7.4.6 x86_64 RPMS
  234. Re: Reusable database design
  235. Shared disk
  236. Re: Get diagnistic (row_count) 7.3 vs. 7.4 changes
  237. Re: Performance tuning on RedHat Enterprise Linux 3
  238. Re: vacuum problem?
  239. Re: vacuum problem?
  240. Sql performace - why soo long ?
  241. Postgres not using shared memory