PDA

View Full Version : Pgsql General

  1. Storing blobs in PG DB
  2. Finding Queries that have been done on a DB
  3. Re: Using MS Access front-end with PG]
  4. Using MS Access front-end with PG
  5. a couple of newbie question - deferrable, varchar vs text, 2 dbs
  6. assistance needed for autovacuum on the windows version of 8.2.3
  7. Re: assistance needed for autovacuum on the windows version of 8.2.3
  8. Nice, web-based SNMP-Frontend for pgsnmpd?
  9. speeding up a query
  10. PSQL - Slow on Windows 2000 or Windows 2003
  11. UPDATE on two large datasets is very slow
  12. PSQL - Slow on Windows 2000 or Windows 2003
  13. PGSQL with high number of database rows?
  14. sql schema advice sought
  15. inserting multiple values in version 8.1.5
  16. ECPG: inserting NULL values when using prepared statements
  17. documentation generator for pgsql
  18. Re: SQLConnect failure
  19. SQLConnect failure
  20. best way to calculate accumulating intervals timestamps
  21. pg_live
  22. Importing data into views fails
  23. Webappication and PostgreSQL login roles
  24. Unexplained case insensitive results
  25. Wrong increments of Sequence
  26. Re: ERROR: out of shared memory
  27. Re: Problem restoring from backup file
  28. A little help for big forms
  29. use superuser connection from php
  30. Working between Windows and Unix
  31. Urgent job opening for PostgreSQL DBA.
  32. Urgent job opening for PostgreSQL DBA.
  33. =?iso-2022-jp?B?GyRCRn42YiRyJDUkOyRGRDokMSReJDskcyQrISkbKEI=? =
  34. Problem restoring from backup file
  35. Connecting a sequence with table column
  36. postgresl for mysql?
  37. plpy prepare problem
  38. queries stop using indexes
  39. PlPg/SQL
  40. Default value of column not respecting character length or domain restraints.
  41. introduction of FK results in no data insert
  42. VACUUM FULL takes long time to complete
  43. Unusual PK contraint error
  44. Instalation problem
  45. Arrays instead of join tables
  46. Array extraction
  47. Anyone know where I can get an 8.2.3 binary for ubuntu?
  48. calling a stored procedure using sql query in 7.4
  49. job opportunity with Hedge Fund - NYC
  50. Tsearch2 crashes my backend, ouch !
  51. PANIC: unexpected hash relation size
  52. Using C# to create stored procedures
  53. stored queries and quoted strings
  54. Re: Oracle to PSQL function
  55. Deleted Flag/Unique Constraint
  56. pg_standby
  57. coalesce for null AND empty strings
  58. to build a vocabulary
  59. Codifica database
  60. Postgres 8.2.3 or 8.1.8?
  61. Postgres Crash Running PLPGSQL Function on 8.2.3
  62. Mentor
  63. Oracle to PSQL function
  64. Re: question: knopixx and postgresql on flash drive
  65. cursors in postgres
  66. pgAgent Crash on WinXP
  67. Reading from a text file, or unix console screen
  68. Btree indexes, large numbers and <= comparisons
  69. Timestamp precision
  70. COPY command details
  71. inserting 4800 records at a time
  72. Order by behaviour
  73. pg_dump is stuck
  74. how to know a table size ?
  75. disable/enable trigger hangs
  76. Slow sequential scans on one DB but not another; fragmentation?
  77. How to speedup CHECKPOINTs?
  78. Some encoding trouble via libpq
  79. Paranthesis and Driver JDBC
  80. [ANNOUNCE] echoping 6, with a PostgreSQL plugin
  81. performance of fixed length columns-only tables
  82. Prepared queries vs Non-prepared
  83. tweaks for write-intensive dbs ?
  84. Re: tweaks for write-intensive dbs ?
  85. load the whole database into RAM
  86. custom type for storing a HTML color
  87. redhat debug info
  88. Strange behaviour under heavy load
  89. Re: [pgsql-advocacy] Is there a shortage of postgresqlskilled ops people
  90. Populate a calendar table
  91. Re: cutting out the middleperl
  92. Is there a shortage of postgresql skilled ops people
  93. Constraint and Index with same name? (chicken and egg probelm)
  94. Query that does not use indexes
  95. libpq dependencies
  96. How can I select a comment on a column?
  97. ERROR: out of shared memory
  98. VACUUM ANALYZE
  99. Strange result using transactions
  100. pg_dump without psql rights
  101. RBC Financial Group
  102. Temporarily disable all table indices
  103. Problem with transactions
  104. A (hopefully) simple question re: secure pg <=> webapplication access
  105. get value after updating table
  106. Could not create relation: File exists error
  107. Re: replication of data from postgresql DB on File System Level
  108. PG over NFS
  109. Create table from view, large data - out of memory (postgresql8.2.0)
  110. Log Query and Execution time
  111. Server memory and efficientcy
  112. Matrix (linear algebra) operations and types in PG?
  113. Tsearch2 can't be checked for equality?
  114. postgres error message upon boot
  115. PostgreSQL PAM function contrib
  116. Check the existance of temporary table
  117. automatic value conversion
  118. Howto optimize pg 8.1.4 and FC6 x64 ??
  119. concurrency in stored procedures
  120. Re: shell script to SQL statement: `pg_dump | psql -U`
  121. Async triggers
  122. question: knopixx and postgresql on flash drive
  123. [Fwd: postgres dev question - MVCC slowdown]
  124. Query not using index pgsql 8.2.3
  125. VACUUM ANALYZE
  126. Every user has own database - how?
  127. database-wide triggers
  128. cutting out the middleperl
  129. making postgres DB stable, efficient and secure
  130. using 'ALTER ROLE' in a function
  131. Deadlock with REINDEX TABLE
  132. A request for your input.
  133. foreign key constraints with inhertiance, hack suggestions?
  134. Server
  135. xpath_list() function
  136. Configuring phpPgAdmin and pg_ctl reload
  137. Dealing with table names in functions
  138. Re: Configuring phpPgAdmin and pg_ctl reload
  139. questions about query design
  140. Re: Server
  141. Problem on installing postgresql-devel
  142. PostgreSQL 7.3.4 using Cygwin on a Windows 2003 Server R2 SP2
  143. Re: Dealing with table names in functions
  144. best way to kill long running query?
  145. sql indexing suggestions needed
  146. multi terabyte fulltext searching
  147. Limiting user connnections on 7.4
  148. can't trace error!!!
  149. multi terabyte fulltext searching
  150. Remove add_missing_from_clause?
  151. Anyone still using the sql_inheritance parameter?
  152. CHAR data type
  153. to_tsvector in 8.2.3
  154. invalid byte sequence for encoding "UTF8"
  155. Bulk Data Entry
  156. Postgres Hot Standby. How or when does the recovery db move recovery.conf to recovery.done?
  157. Using PostgreSQL to archive personal email
  158. Approximate join on timestamps
  159. "sniffing" postgres queries
  160. multi-row check constraints?
  161. select progressive total
  162. sql indexing suggestions needed
  163. Postgresql to Delphi
  164. Reminder: only 5 days left to submit SoC applications
  165. pg installation for dummies
  166. LISTEN/NOTIFY and python
  167. shell script to SQL statement: `pg_dump | psql -U`
  168. Job Opening for PostgreSQL DBA in Pune.
  169. Unable to start postgres in recovery mode.
  170. Re: java.net.SocketException: Connection reset
  171. Reference Type in PostgreSQL
  172. PostgreSQL Party, July 22nd 2007 (Day before OSCON 2007)
  173. Optimizing warm standby. Will this work? [PITR WAL]
  174. TSearch2 Problems
  175. Re: cannot get build (initdb) to work after trying fora week
  176. DBD:Pg for Windows (PostgreSQL+Perl)
  177. anyone heard of/use SurfRAID Triton product with postgres?
  178. Planner tuning
  179. deleting a foreign key that has no references
  180. How to recognize obsolete WAL logs
  181. Stored Procedure / function and their result
  182. Client/Server [max connections]
  183. cache - timing
  184. Shell script to determine if PostgreSQL is accepting connections?
  185. Re: PgSql on Vista?
  186. Own messages for constraints?
  187. Design / Implementation problem
  188. UPGRADATION TO 8.1
  189. Re: [PHP] works at command line but not in apache
  190. issue with SELECT settval(..);
  191. Postgres Database size
  192. dump strored function
  193. how can i show constraint checks in explain ?
  194. Store Procedures
  195. cannot get build (initdb) to work after trying for a week
  196. Creation of a read-only role.
  197. Possible planner bug?
  198. Oracle-PostgreSQL Coexistence/Interoperability (segue fromPostgreSQL to Oracle)
  199. planning issue
  200. Re: PostgreSQL 8.2.3 VACUUM Timings/Performance
  201. Bug in CREATE/DROP TABLESPACE command
  202. Re: pg_dumpall and version confusion
  203. Re: pg_dumpall and version confusion
  204. Dump a function
  205. Query Assistance
  206. Column does not exist when trying to insert data.
  207. About the new day-time saving rule
  208. Re: About the new day-time saving rule
  209. exception handling in plperlu
  210. pg_dump warning format?
  211. Re: [SQL] PostgreSQL to Oracle
  212. Problem to install pgAdmin
  213. Fwd: Native type for storing fractions (e.g 1/3)?
  214. simple coordinate system
  215. Re: DST problem on Windows Server
  216. Re: Could you send me a copy of pg8.1beta1?Thank you very much!
  217. java.net.SocketException: Connection reset
  218. plperl question: how to specifiy perl version?
  219. query advice
  220. pg_dumpall and version confusion
  221. Role & User - Inheritance?
  222. PLpgSQL debugger
  223. Re: Plperl Question
  224. Automating access grants
  225. plperl function called > once in cascading triggers
  226. Native type for storing fractions (e.g 1/3)?
  227. 30ms to 30s execution time: query optimization problem
  228. Lifecycle of PostgreSQL releases
  229. database locks
  230. CREATE TABLESPACE dynamically
  231. Re: Debugging Server Code
  232. Debugging Server Code
  233. pre-parser query manipulation
  234. How to write a function that manipulates a set of results
  235. DST problem on Windows Server
  236. quoted identifier behaviour
  237. Plperl Question
  238. Re: grant permissions to set variable?
  239. Trigger Question
  240. max_connections (postgresql.conf)
  241. Windows psql.exe password from pgpass.conf
  242. PgAgent
  243. Multiple TRIGGERs and OLD versus NEW "records"
  244. Statement logging
  245. PgSql on Vista?
  246. information_schema.table_privileges
  247. Where is contrib?
  248. Multiple atributes with -P switch to psql
  249. Exception handling in plperl
  250. PITR and WAL archiving