PDA

View Full Version : Pgsql General

  1. Please explain the gin index
  2. Fuzzy Querys
  3. function taking a long time. any options o speed it up.
  4. Antw: Re: Performance problem with query
  5. PostgreSQL on Embeded Systems
  6. UTF8 conversion differences from v8.1.3 to v8.1.4
  7. SELECT * WHERE id IN (list of ids)
  8. Re: Newbie help please....
  9. Re: Newbie help please....
  10. pg_restore failes - invalid byte sequence for encoding "UNICODE": 0xa3
  11. postgreSQL installation
  12. INSERT 0 1 "problems"
  13. permission to create user
  14. Simple webuser setup
  15. Postgresql and Oracle
  16. Re: I have a questions, can you help-me ?
  17. Scaleable DB structure for counters...
  18. Log actual params for prepared queries: TO-DO item?
  19. Limited Availability
  20. Browse database , schema
  21. PGSQL 8.1.4 on Win2003 at istanbul :), could not access status of transaction xxxxx , could not open file "pg_subtrans/000A": Invalid argument
  22. How to access a table from one database to another database
  23. Re: apparent wraparound
  24. Antw: Re: Problem with archive_command
  25. Antw: Problem with archive_command
  26. apparent wraparound
  27. Windows Local Security Policy Rights?
  28. Q: Table scans on set difference
  29. Antw: Re: Performance problem with query
  30. How to see function & triggers definition?
  31. Problem with archive_command
  32. table replication, without master-slave setup
  33. How to read cleartext user password from pgsql database
  34. Function Help
  35. Timestamp vs timestamptz
  36. How come index isn't being used when query by function return value?
  37. =?UTF-8?Q? Re: =3D???UTF-8?Q?re: How to insert .xls...?=
  38. databases hidden in phppgadmin
  39. Clustering and backup with large objects
  40. Re: I need help creating a query
  41. I need help creating a query
  42. SPI based table locks.
  43. Is there a way to run tables in RAM?
  44. Database connectivity using ECPG
  45. VPD
  46. stored function - array parameter - how many element in array ?
  47. Trying to connect to an Oracle instance...
  48. Trying to perform a connection to Oracle
  49. Physical block structure in PostgreSQL
  50. Performance problem with query
  51. cant connect to the database, even after doing start of postmaster using a script
  52. db clustering?
  53. Delete Problem
  54. SQL Standards Compliance With Case
  55. Mailing lists again
  56. Re: Long term database archival
  57. ON INSERT view rule
  58. Re: Long term database archival
  59. getting function argument names from psql?
  60. disk space usage
  61. Crystal Reports 8.5 - SQL Expressions
  62. HardDisk space
  63. 8.2 Beta ETA
  64. Re: doesn't recognize "!=-" (not equal to a negative value)
  65. Including C/C++ header files containing #defines using EXEC SQL INCLUDE
  66. PostgreSQL Server Crash using plPHP or PL/Perl
  67. doesn't recognize "!=-" (not equal to a negative value)
  68. troubleshooting 8.1.2
  69. SQL parsing suggestions?
  70. Re: [pgadmin-support] Emergency - postgre is not working
  71. Error code 1063
  72. Error code 1063
  73. Dynamic table with variable number of columns
  74. Passwords problems
  75. Getting progress of operation
  76. A function which returns all rolname from pg_roles.
  77. customizing pg_dump together with copy.c's DoCopy function
  78. Re: US Telephone Number Type
  79. unsubscribe
  80. encoding bug or feature?
  81. US Telephone Number Type
  82. Background Writer and performances
  83. How to restrict select from table with external validation?
  84. Aim of --enable-thread-safety ?
  85. Problem with COPY
  86. Autovacuum Logging Info?
  87. having indexes when clearing tables
  88. Procedural language functions across servers
  89. Mobile servers replication
  90. Version Discrepancy
  91. =?UTF-8?Q?RE: migration from Sybase to Postgres?=
  92. Is OpenFTS dead?
  93. Re: Bug? Changing where distinct occurs produces error?
  94. =?UTF-8?Q?re: How to insert .xls files into database?=
  95. Bug? Changing where distinct occurs produces error?
  96. Re: VACUUM FULL versus CLUSTER ON
  97. How to insert .xls files into database
  98. VACUUM FULL versus CLUSTER ON
  99. Can Log filename include database name?
  100. Addressing: ERROR: could not access status of transaction
  101. Need help with quote escaping in exim for postgresql
  102. =?UTF-8?Q?migration from Sybase to Postgres?=
  103. How to sample records
  104. How to optimize query that concatenates strings?
  105. Do checkpoints flush all data from shared buffers ?
  106. WAL internals
  107. VACUUM and fsm_max_pages
  108. Partition Rule Updating While Running?
  109. Postmaster is starting but shutting when trying to connect (Windows)
  110. Version/Change Management of functions?
  111. The HP MSA20 SATA-SCSI enclosure
  112. Re: Long term database archival
  113. Re: Old data (was Re: Long term database archival)
  114. PANIC: XX000: right sibling is not next child in "pg_depend_reference_index"
  115. Re: duplicated values on primary key field on reindex
  116. duplicated values on primary key field on reindex
  117. Re: [BUGS] BUG #2517: Trouble with cx_Oracle and Plpython
  118. Granting COPY FROM access
  119. Granting COPY FROM access
  120. Best way to deal with quote_literal issue?
  121. Long term database archival
  122. Delete cascade and trigger permissions?
  123. Granting COPY FROM access
  124. Backing up the currently used wal segment
  125. Help to sample a table
  126. FOR from query - is it a bug ?
  127. Modeling Tool
  128. Granting COPY FROM access
  129. Granting COPY TO access
  130. How do I revoke CREATE TABLE and other privileges?
  131. basic log question
  132. Re: [JDBC] Is what I want possible and if so how?
  133. ECPG usage
  134. Help making a plpgsql function?
  135. Dumping in LATIN1 and restoring in UTF-8
  136. How to hide NOTICE messages in psql.exe ?
  137. Inheritance and unique constraints
  138. How to bypass perm pb on information schema. Request of review
  139. Postgres & CODA
  140. OLEDB connection does not want to work. Help!!
  141. Re: RAID + PostgreSQL?
  142. Phantom groups
  143. Automatic Installer
  144. High-Availability Question
  145. Re: [JDBC] Is what I want possible and if so how?
  146. How serious are these problems?
  147. php can't connect to postgresql server
  148. Optimizing query: select ... where id = 4 and md5(...) = '...'
  149. Re: Is what I want possible and if so how?
  150. query execution time
  151. Is there a command like uf_purge
  152. libpq: bind message supplies 2 parameters, but prepared statement requires 1
  153. Permission denied: logfile
  154. PostgreSQL or mySQL
  155. Default directory for postgres user?
  156. pgsql user change to postgres
  157. Techdocs error (WAS: RE: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4)
  158. How to Backup like in mysql or ms sql server
  159. Re: Is there any way to index or cache a view, or function results?
  160. Is there any way to index or cache a view, or function results?
  161. Postgresql does not start on reboot
  162. Re: Dynamic technical graphics generation inside plperl query?
  163. SELECT statement in stored procedure
  164. stored procedure which return a select result
  165. db question - dynamic fields in db
  166. stored procedures
  167. pgsql vs mysql
  168. limit results to one row per foreign object
  169. Re: Notes on converting from MySQL 5.0.x to PostgreSQL
  170. PostgreSQL and OpenVZ
  171. Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
  172. Installation problems
  173. different sort order in windows and linux version
  174. phppgadmin
  175. finding gps within polygon
  176. Database connectivity using a unix shell
  177. Re: Script for reading flat file without delimiters
  178. Script for reading flat file without delimiters
  179. phppgadmin
  180. PHPpgadmin and user privileges
  181. pg_restore: [archiver] could not open input file
  182. User privileges in web database applications
  183. Is it possible to disable insert/update/delete triggers for one transaction and not another?
  184. Strange Behavior with Serializable Transcations
  185. unusual "relation xxx does not exist" problem
  186. Upgrade problem
  187. empty text fields
  188. invalid primary checkpoint record
  189. Null and Void() - Or, Abandon All Hope Ye Who allow NULLs?
  190. Re: RAID + PostgreSQL?
  191. How can I speed up this query?
  192. UUID's as primary keys
  193. graph plottin engines compatible with postgres
  194. restrict user rights
  195. About libpq
  196. Re: RAID + PostgreSQL?
  197. Question concerning arrays
  198. Anonymous PL functions?
  199. TSearch vs. Homebrew
  200. Re: RAID + PostgreSQL?
  201. Preformace boost -- by 8.0.4 upgrade to 8.1.4
  202. FKs Lock Contention
  203. psql -h host ...
  204. list or regular expressions
  205. inheritance and table
  206. Re: initlocation on 8.0+
  207. initlocation on 8.0+
  208. unique attributes in profile management system
  209. RAID + PostgreSQL?
  210. update impossible, constraint prevents it but it shouldn't
  211. limit over attribute size if index over it exists
  212. Casting and Timestamp
  213. oh dear - have i messed up my OIDs?
  214. "Ghost" colmumn with primary key
  215. casting... adding integer to timestamp
  216. Re: Changing encoding of a database
  217. pg_dump With OIDs Supported?
  218. Re: Plperl and my() lexical variables bug?
  219. JUST NOT ADDING UP
  220. Documentation of the Front End/Back End Protocol for Large Objects
  221. Copy from text file
  222. Idea for vacuuming
  223. autovacuum template0
  224. aggregate of bitstrings
  225. Re: Out of memory error in 8.1.0 Win32
  226. OT: publicly available databases?
  227. auto-vacuum & Negative "anl" Values
  228. sequence in select
  229. Re: Form builder?
  230. cpan perl module - plperlu danger?
  231. Bitwise OR in a group statement
  232. Help from Havana
  233. XML Support
  234. Interface Guidance and Opinions Needed
  235. Unable to start pg service
  236. Changing array subscripting to zero-offset
  237. sql question; checks if data already exists before inserted
  238. Missing domain socket after reboot.
  239. Re: Out of memory error in 8.1.0 Win32
  240. Form builder?
  241. performance tips please
  242. MS-SQL2PostgreSQL
  243. VACUUM hanging on idle system
  244. Dynamic loading of C functions: Badly stuck
  245. unsubscribe
  246. MAKE UNLIMITED MONEY USING PAYPAL!!! $5.00 ONE TIME FEE!!!
  247. OLEDB Provider for Postgres
  248. problem enabling postgres in php
  249. multiple statement 'instead of' rule
  250. Lock contention during inserts