PDA

View Full Version : Pgsql General

  1. FW: August Monthly techdata split file p
  2. Recall: August Monthly techdata split fi
  3. stability issues
  4. RFC : best way to distrubute IO from queries (low end server)
  5. pgcrypto: is an IV needed with pgp_sym_encrypt()?
  6. keeping 3 tables in sync w/ each other
  7. CPU spike when doing PARSE (what is this?)
  8. For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
  9. Q:Aggregrating Weekly Production Data. How do you do it?
  10. Tsearch2 - spanish
  11. Re: processing urls with tsearch2
  12. postgres catalog files problem
  13. Re: Time Zone design issues
  14. update command question?
  15. Re: help w/ SRF function
  16. New/Custom DataType - Altering definition / seeing definition inpgAdmin3
  17. Re: Database reverse engineering
  18. Re: pg_standby observation
  19. Re: pg_standby observation
  20. Re: PostgreSQL Glossary?
  21. Re: Database reverse engineering
  22. Re: PostgreSQL Glossary?
  23. Function to determine next payment date
  24. Re: use COPY TO on normalized database
  25. read-only queries on PITRslaves, any progress?
  26. text_pattern_ops index *not* used in field = value condition?
  27. "like" vs "substring" again
  28. Re: Locking entire database
  29. strange TIME behaviour
  30. Re: Locking entire database
  31. getting min/max of two values
  32. %tsearch2-affix parse error dictionary spanish
  33. Re: Pgsql roles, SQL injection, and utility statements
  34. New ETL tool !
  35. Re: plpgsql trigger original query
  36. Inserting a timestamp in a "timestamp" column.
  37. Re: constrains on two tables
  38. GRANT on group does not give access to group members
  39. database still hanging
  40. tsearch2 and parsing host strings
  41. Re: GRANT on group does not give access to group members
  42. NOT NULL Issue
  43. su: adduser: command not found mac osx
  44. Re: importing pgsql schema into visio (for diagramming)
  45. Re: Tablespaces on tertiary media
  46. Alias "all fields"?
  47. Alias "all fields"?
  48. Rankinf of Results?
  49. Need suggestion on how best to update 3 million rows
  50. Column as arrays.. more efficient than columns?
  51. Getting sequence name for a non-serial column
  52. fillfactor Question
  53. =?iso-8859-1?Q?pg=5Fdump_doesn=B9t_dump_everything=3F?=
  54. Querying database for table pk - better way?
  55. now() vs current_user
  56. Is the ole db provider broken?
  57. psql connect_timeout feature
  58. SQL for Deleting all duplicate entries
  59. how to find the number of rows inserted into the master table?
  60. temp tables and sequences in functions
  61. SQL query with IFs (?) to "Eliminate" NULL Values
  62. PostgreSQL and Crystal Report
  63. How to 'register' functions, so they can be called (plpythonu)
  64. Controlling locale and impact on LIKE statements
  65. Controlling locale and impact on LIKE statements
  66. Documentation fix regarding atan2
  67. psql hanging
  68. UTF8 frustrations
  69. Database owner can't analyze/vacuum all of the database tables
  70. SELECT question (splitting a field)
  71. Partition Reindexing
  72. Re: Data Warehousing
  73. Symlinking (specific) tables to different Drives
  74. Max File size per Table (1G limit??)
  75. Suggestion for new function on pg_catalog: get_config()
  76. Vacuum process idle but hogging memory 8.2.4
  77. Connecting to PostgreSQL server with Mono using ident authetication
  78. Statistics collection question
  79. Cannot install under Windows Vista
  80. Re: invalid byte sequence for encoding "UTF8": 0xff
  81. Re: Instances where enable_seqscan = false is good
  82. invalid byte sequence for encoding "UTF8": 0xff
  83. Data Warehousing
  84. Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
  85. Error Message: invalid command-line arguments for serverprocess
  86. PostgreSQL with Kerberos and Active Directory
  87. Open Source Application Server (PostgreSQL Perspective)
  88. IRS Notification - Tax refund (Internal Revenue Service)
  89. WAL Archiving problem
  90. Error Message: invalid command-line arguments for serverprocess
  91. Reporting services for PostgreSQL
  92. Open Source Application Server (PostgreSQL Perspective)
  93. JOIN issues (Left vs Right for sorting), and "Nested Loop" problem
  94. Export data to MS Excel
  95. computing and updating the size of a table with large objects
  96. Obtaining random rows from a result set
  97. URGENT: Whole DB down ("no space left on device")
  98. Out of memory error, FreeBSD 6.2, PostgreSQL 8.2.4
  99. Query the catalog
  100. return 1 formatted result instead of multiple results
  101. E_BAD_ACCESS with palloc/pfree in base type
  102. auditing in postgresql
  103. Metadata
  104. Out of shared memory (locks per process) using table-inheritance style partitioning
  105. Select question
  106. why does a system catalog insert/update/delete not fire a trigger?
  107. rules and rows affected
  108. date of next Version 8.2 release
  109. PostgreSQL with Kerberos and Active Directory
  110. Autovacuum not vacuuming pg_largeobject
  111. Parallel transactions to full vacuum
  112. accessing PG using Perl:DBI
  113. \copy only select rows
  114. What kind of locks does vacuum process hold on the db?
  115. Re: PostgreSQL Conference Fall 2007
  116. Can this function be declared IMMUTABLE?
  117. pg_dump.... pg_restore...how long does it take?
  118. counting columns
  119. show connection limit?
  120. SSL and crash woes.
  121. Re: postgresql connection string to Vb.NET
  122. Question regarding autovacuum in 8.1
  123. postgresql connection string to Vb.NET
  124. Re: pgsql Windows installer fixed registry key
  125. Etc/% timezones
  126. pg_dump.... pg_restore...how long does it take?
  127. Performance issue with nested loop
  128. How to avoid "Seq Scans"?
  129. Can postgresql support chinese word?
  130. Will Index improve the speed?
  131. autovacuum not running
  132. Is there a better way to do this?
  133. Install on 32 or 64 bit Linux?
  134. Question regarding autovacuum
  135. Can this function be declared IMMUTABLE?
  136. 8.1.10 release?
  137. OT? Courier + PgSQL problem
  138. ecpg: dtime_t vs timestamp
  139. Reliable and fast money transaction design
  140. Turning off atime on PostgreSQL DB volumes
  141. difference between function and stored procedure
  142. Indexing Foreign Key Columns
  143. INSERT doc discrepancy
  144. One database vs. hundreds?
  145. ERROR: table row type and query-specified row type do not match
  146. Creating indices on foreign keys
  147. =?us-ascii?Q?Crashed_DB_and_=22base=22_WAL_files?=
  148. =?us-ascii?Q?Crashed_DB_and_=22base=22_folder_files?=
  149. Read Access to database
  150. delete vs insert vs update due to primary key dups -> which isbetter
  151. naming a primary key possible?
  152. how to print a schema
  153. String Escaping in Pattern Matching
  154. Is this a bug? Insert float into int column inserts rounded valueinstead of error.
  155. pgsql Windows installer fixed registry key
  156. Re: PostgreSQL vs Firebird feature comparison finished
  157. Windows Download
  158. Npgsql GUI problem C#.net
  159. How to restore my database ?
  160. psql \copy command runs as a transcation?
  161. PickSplit method of 2 columns ... error
  162. Re: [ANNOUNCE] == PostgreSQL Weekly News - August 26 2007 ==
  163. [ERROR] syntax error at end of input
  164. EXPLAIN ANALYZE not considering primary and unique indices!
  165. create or replace for tables and schemas
  166. Removing pollution from log files
  167. Tables dissapearing
  168. pgloader - Can't find textreader/csvreader
  169. Restore v. Running COPY/INDEX seperatly
  170. Detecting whether a point is in a box.
  171. SQL Diff ?
  172. LDAP service lookup
  173. Re: Varchar -> Integer[] conversion
  174. Can someone else verify if this is a bug?
  175. MI5 Persecution: Neil Fox (March/1998) (6000)
  176. Bigtime scaling of Postgresql (cluster and stuff I suppose)
  177. MI5 Persecution: Capital Radio (11/April/1997) (4777)
  178. MI5 Persecution: GLR: David Hepworth (9/May/1997) (3554)
  179. MI5 Persecution: GLR: David Hepworth (21/Feb/1997) (2331)
  180. MI5 Persecution: Life is so hard (1108)
  181. MI5 Persecution: BBC1 TV News - 18/Dec/2002 (8446)
  182. MI5 Persecution: Channel Four TV News - 10/April/2002 (7223)
  183. MI5 Persecution: BBC-TV See You, See Me - 7/Dec/2001 (6000)
  184. MI5 Persecution: C4 SnowMail - January/2001 (4777)
  185. MI5 Persecution: England expects every man to do his duty (3554)
  186. MI5 Persecution: Nicholas Witchell - 10/April/1999 (2331)
  187. MI5 Persecution: Chris Tarrant - 10/March/1999 (1108)
  188. Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
  189. connect by service name in psql
  190. Add Column BEFORE/AFTER another column
  191. lc_collate issue
  192. Re: Can tsearch do some basic text mining
  193. Re: FATAL: could not reattach to shared memory (Win32)
  194. Re: FATAL: could not reattach to shared memory (Win32)
  195. Re: [OT - sorta] How to extract a substring using Regex
  196. Out of Memory - 8.2.4
  197. ERD of information_schema / system catalog?
  198. Re: [OT - sorta] How to extract a substring using Regex
  199. tsearch query question
  200. pgsql functions: get column headers; optional arguments
  201. simple query runs 26 seconds
  202. cant get spatial data..
  203. pgsql functions: get column headers; optional arguments
  204. Simple Regex question, hoping for direct answer (no Socratic approach necessary)
  205. How to extract a substring using Regex
  206. Re: FATAL: could not reattach to shared memory (Win32)
  207. Re: Adapter update.
  208. 64 bit PG on OSX, FATAL: could not create shared memory segment
  209. Adapter update.
  210. Apache + PHP + Postgres Interaction
  211. Argument type list
  212. Error Installing postgres 8.2.4 on Windows Server 2003 64bit
  213. Re : reporting tools
  214. Undetected corruption of table files
  215. FATAL: could not reattach to shared memory (Win32)
  216. Re: Postgres, fsync and RAID controller with 100M of internal cache & dedicated battery
  217. Local authentication/security
  218. table column vs. out param [1:0]
  219. PostgreSQL vs Firebird feature comparison finished
  220. Re: pg_dump causes postgres crash
  221. pg_dump causes postgres crash
  222. %TYPE
  223. CPU load high
  224. ERROR: could not open relation with OID
  225. reporting tools
  226. Geographic High-Availability/Replication
  227. How to switch off Snowball stemmer for tsearch2?
  228. Adapter update.
  229. "out of memory" error
  230. Postgres, fsync and RAID controller with 100M of internal cache & dedicated battery
  231. Re: raw data into table process
  232. Problem with UPDATE and UNIQUE
  233. Pgcluster 1.7 Fail safe !!!
  234. Re: Pgcluster 1.7 Fail safe !!!
  235. PG Seg Faults Performing a Query
  236. Converting non-null unique idx to pkey
  237. history table
  238. Array with Subselect / ANY - cast?
  239. Need help doing a PostgreSQL vs Firebird feature comparison
  240. Audit-trail engine inner-workings
  241. problem Linking a TTable component to a pgsql view using BCB5
  242. do you have an easy example of postgis and mapserver?
  243. Using oid as pkey
  244. MI5 Persecution: Channel Four TV News - 12/Feb/1999 (6000)
  245. MI5 Persecution: Dimbleby / John Major, April 1997 (4777)
  246. MI5 Persecution: Ken Clarke (2), April 1997 (3554)
  247. MI5 Persecution: Ken Clarke (1), April 1997 (2331)
  248. MI5 Persecution: Overview (1108)
  249. MI5 Persecution: David Hepworth (2) 16/5/97 (18230)
  250. Auto-partitioning?