PDA

View Full Version : Pgsql General

  1. postgresql is slow with larger table even it is in RAM
  2. Need help to migrate pqSQL db 8.0.3 to 8.2.6
  3. OLEDB vs ODBC to access postgres
  4. Install Postgresql on Win2000 with Admin Rights
  5. date and time
  6. Checking if Aggregate exists
  7. Problem with update on partitioned table
  8. Toast Table
  9. help optimizing query
  10. ALTER TABLE with USING clause for timestamp
  11. Postgres connection error
  12. Re: Postgres development
  13. Re: MySQL to Postgres question
  14. Re: MySQL to Postgres question
  15. How to concatenate a boolean to a text string for an EXECUTE stmtin a stored proc
  16. scheduling stored procedure
  17. INFINITE RECURSION with rules...
  18. Insert
  19. tabs in psql
  20. table size and storage location
  21. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  22. Transaction wraparound problem with database postgres
  23. Trigger transactions
  24. Postgresql partitioning
  25. Installing on Windows without using msi Installer
  26. C function and enum types parameters
  27. begin-end blocks in psql
  28. Re: 8.3.0 upgrade
  29. MySQL to Postgres question
  30. Re: Transaction wraparound problem with database postgres
  31. --enable-thread-safety bug
  32. Re: cast problem 8.3.1
  33. deadlock error messages
  34. ecpg program getting stuck
  35. MySQL to Postgres question
  36. Re: [postgis-users] how many min. floating-points?
  37. Re: dynamically generated SQL and planner/performance
  38. createuser: could not connect to database postgres: FATAL: could not open file "global/pg_database": No such file or directory
  39. Re: Which JDBC version to use with PostgreSQL 8.1.11?
  40. cursor manipulation
  41. PGSQL database size question
  42. Cast character to boolean
  43. Table size
  44. Running function automatically on (unclean) disconnect
  45. Re: beginner: what permissions required to install on windows 2000+
  46. Re: Problem with async notifications of table updates
  47. Feature request/suggestion - CREATE SCHEMA LIKE
  48. identify database process given client process
  49. postgresql performance tuning tools
  50. Catch-22
  51. Get info about indexes
  52. Get index information from information_schema?
  53. Re: LOCK TABLE HELP
  54. array function problem
  55. Re: 8.3.0 upgrade
  56. Re: Cannot Install PostgreSQL on Windows 2000 Server
  57. Redundant file server for postgres
  58. UPDATE stalls when run in "batch mode"
  59. Updating
  60. Permission template
  61. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  62. Re: how to make this database / query faster
  63. Re: how to make this database / query faster
  64. on insert when ... do instead update
  65. Making a schema "read-only" (was Unexpected message in grant/revoke script)
  66. Unexpected error in grant/revoke script
  67. Unexpected message in grant/revoke script
  68. SQL UPDATE question
  69. How to silence psql notices, warnings, etc.?
  70. shared memory/max_locks_per_transaction error
  71. Re: LOCK TABLE HELP
  72. Blobs
  73. Re: Please Help! Was: Multithread problem: Error intransaction processing
  74. LOCK TABLE HELP
  75. GRANT giving error on sequence in 7.4.19
  76. forcing use of more indexes (bitmap AND)
  77. pgbench not setting scale size correctly?
  78. PG secure for financial applications ...
  79. Question about the cluster command
  80. Using MicroOLAP DAC to connect to Database - Problem with Grid
  81. tsearch2 word separators
  82. empty pg_stat user views
  83. Segmentation fault (core dumped) loading data on 8.3 upgrade: undefinedsymbol 'pg_valid_server_encoding_id',lazy binding failed!
  84. Dump format for long term archiving.
  85. My CPU usage remains over 50% with Postgre
  86. =?ISO-8859-1?Q?Percent-encoding_conversion_to_binary=2C_%C2%A9_?==?ISO-8859-1?Q?=3D_=A9?=
  87. pgfoundry is down
  88. ER diagram tool
  89. Generate schema like uml diagrams from existing db
  90. WAL Archiving Error
  91. Segementation fault in PQgetvalue()
  92. Recomendations on raid controllers raid 1+0
  93. Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT ....ON COMMIT DROP
  94. Reindex does not finish 8.2.6
  95. Column Statistics - How to dertermine for whole database
  96. Duplicate key violation on UPDATE
  97. porting vb6 code to pgplsql, referencing fields
  98. porting vb6 code to pgplsql, referencing fields
  99. table size in 8.3
  100. Service Account password
  101. Re: Checking is TSearch2 query is valid
  102. Subplan and index usage
  103. PostgreSQL won't start
  104. Function Returning SETOF RECORD: Trouble With Char Type
  105. Functional Index Question
  106. oralink
  107. PostgreSQL user documentation wiki open for business
  108. Can't rename an existnig DB because it doesn't exist???
  109. Using PL/R for predictive analysis of data.
  110. pain of postgres upgrade with extensions
  111. porting vb6 code to pgplsql, referencing fields
  112. migration of 7.4 to 8.1
  113. SELECT overhead in explicit transaction
  114. SELECT in explicit transaction
  115. Problem with starting PostgreSQL server 7.4.19
  116. FROM + JOIN when more than one table in FROM
  117. simple UPDATE statement...
  118. Array load from remote site through Perl/DBI
  119. Re: Relocation error:
  120. Trouble with Savepoints in postgres
  121. Normalizing denormalization with materialized views
  122. basic plpgsql / sql funtion question
  123. How to convert postgres timestamp to date: yyyy-mm-dd
  124. ERROR: text search configuration "pg_catalog.english" does not exist
  125. postgre vs MySQL
  126. list user created triggers
  127. Database OID xxxxx now seems to belong to "foo"
  128. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  129. PostgreSQL and MOLAP ?
  130. message contents do not agree with length in message type "T"
  131. split pg_dumpall backups per database
  132. Relocation error: /usr/lib/libpq.so.5: undefined symbol: krb5_cc_get_principal
  133. searching using indexes 8.3
  134. php pg_connect fails, pgsql works
  135. On defining Perl functions within PLPERL code
  136. pg_type.relacl
  137. Trigger to run @ connection time?
  138. Multithread problem: Error in transaction processing
  139. PostreSQL Single File ( Like M$ Access)
  140. problem with pg_statistic_relid_att_index
  141. Re: my problem for i/o error when i use postgre
  142. Fwd: pgsql configuration
  143. Re: my problem for i/o error when i use postgre
  144. Re: [PERFORM] multi-threaded pgloader makes it in version 2.3.0
  145. pgsql configuration
  146. Reindexdb + relation error
  147. restore_command %r option
  148. ISO something like "#if 0 ... #endif" for SQL code
  149. [Fwd: Re: how do you write aggregate function]
  150. Nested xpath() calls "lose" namespace support
  151. =?us-ascii?Q?large=20object=20import?=
  152. gsoc ideas
  153. Re: v8.3 + UTF8 errors when restoring DB
  154. data import - duplicates
  155. v8.3 + UTF8 errors when restoring DB
  156. loading a psql input file on win xp
  157. cache lookup failed for relation X
  158. cache lookup failed for relation X
  159. Re: Watch your PlanetPostgreSQL.org blogs
  160. Service account not showing
  161. Re: Watch your PlanetPostgreSQL.org blogs
  162. Watch your PlanetPostgreSQL.org blogs
  163. shared_buffers and shmmax what are the max recommended values?
  164. PHPs PDO, apache and "never ending sessions"
  165. pg_standby for solaris x86
  166. Cumulative (Running) Sum
  167. Problems with 8.3
  168. Cannot Install PostgreSQL on Windows 2000 Server
  169. Violation of non existing reference
  170. staring pgsql on fedora 8
  171. Re: I'm in need of something that should be there
  172. Re: Postgresql Page Layout details
  173. mssql to postgres problems with bytea help needed
  174. Postgresql Page Layout details
  175. Ask ctid
  176. Terminal completion
  177. PostgreSQL UK Conference 2008
  178. PostgreSQL vs. MySQL benchmarks on SMP FreeBSD 7.0
  179. Requiring a password
  180. executing query results withing psql
  181. Re: Constraint name for named NOT NULL constraintsis ignored
  182. indexing - creates problem
  183. I'm in need of something that should be there
  184. Changing column names in tables 2
  185. JOIN and difference between timestamps
  186. Changing column names in tables
  187. ER Diagram design tools (Linux)
  188. Re: [SQL] Documenting a DB schema
  189. Re: Documenting a DB schema
  190. Re: Documenting a DB schema
  191. Re: Documenting a DB schema
  192. Re: GRANT ALL ON recursive for all tables in my scheme?
  193. Re: using warm standby with drbd???
  194. I don't understand this WARNING on pg_ctl startup
  195. PGPOOL_HA
  196. Import file into bytea field in SQL/plpgsql?
  197. Find Number Of Sundays Between Two Dates
  198. Meaning og Logs
  199. Re: partitioning using dblink
  200. Build 8.3 with OpenSSL on CentOS 5.x?
  201. Re: beginner: what permissions required to install on windows 2000+
  202. Re:
  203. Checkpoints questions
  204. Question about PostgreSQL's bytea compatibility with MS Access as front-end
  205. how do you write aggregate function
  206. Cross database joins feature request
  207. UUID vs int keys....
  208. [off topic] looking for as/400 advice
  209. Re: PostgreSQL Array Use
  210. Re: beginner: what permissions required to install on windows 2000+
  211. =?Windows-1251?B?ztHNzsLbINPP0MDCy8XNyN8gz9DOxcrSwMzIOiDO0iD IxMXIIMTOINDFwMvIx8DWyMguIMPO0s7C28Ug0MXYxc3I3w==? =
  212. PostgreSQL Array Use
  213. Connect to postgres from a dynamic IP
  214. PostgreSQL Docs - Community Documentation
  215. Re: Connect to postgres from a dynamic IP
  216. Querying Headers
  217. Confused about CASE
  218. Re: beginner: what permissions required to install on windows 2000+
  219. Efficiently storing a directed graph
  220. Design suggestion of multiple databases vs multiple schemas within the database
  221. Unicode comment on Postgres vs Sql Server
  222. 8.2.6 > 8.3 blows up
  223. SERIAL and Primary Key
  224. Problems making client perl connection to postgres server
  225. Schema Export/Import
  226. issue with an assembled date field
  227. Removing Users and Revoking Privileges
  228. Upgrade to 8.3.0?
  229. pgsql structure export to XML
  230. Re: partitioning using dblink
  231. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  232. Re: partitioning using dblink
  233. Re: Insert vs Update syntax
  234. Re: partitioning using dblink
  235. Babase, a PostgreSQL database and an example Foxpro conversion
  236. Insert vs Update syntax
  237. ecpg problem
  238. rule question
  239. Text Search zero padding
  240. =?iso-2022-jp?B?GyRCQCdIczBsRVkkPSROTFwkRzgrJEZNXyQ3JCQkTiRHJ DkhIxsoQg==?=
  241. errors in pg_restore on windows?
  242. partitioning using dblink
  243. syntax errors at "line 1" when executing every command
  244. Space wasted by denormalized data
  245. "Consider compacting this relation..." ???
  246. Re: WAL Log Size
  247. LIMIT Question
  248. initlocation on windows
  249. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  250. "=" or ":=" ?