Sven Willenberger presumably uttered the following on 07/07/06 13:52:
On Fri, 2006-07-07 at 10:41 -0700, Joshua D. Drake wrote:
Sincerely,
Joshua D. Drake
Doing a quick check reveals that the relation in question currently
consumes 186GB of space (which I highly suspect is largely bloat).
On Fri, Jul 07, 2006 at 09:09:22AM -0700, Richard Broersma Jr wrote:
I think that in twenty years, I think most of us will be more worried about
our retirement than
the long terms data conserns of the companies we will no longer be working
for. :-D
You may want to take precautions now such
Magnus Hagander wrote on 08.07.2006 06:21:
This looks exactly like the issues we've seen with broken antivirus or
personal firewall software. Make sure you don't have any such installed
(actualy installed, not just enabled), and if you do try to uninstall
them. If you don't, but had before,
Unfortunately it would appear that I cannot vacuum full either as I get an
out of memory error:
# - Memory -
shared_buffers = 5000 # min 16, at least max_connections*2, 8KB
each work_mem = 131072 # min 64, size in KB
maintenance_work_mem = 524288 # min 1024,
[mailto:[EMAIL PROTECTED] On Behalf Of
On 7 Jul 2006 12:50:22 -, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
What is the most appropriate way to migrate a database form
Sybase (SQL Anywhere 5.504) to Postgres? I found some
shareware of freeware migration tools on the net, which
pg_config is telling us that we are running version 7.3.6-RH, but when
we start psql it shows that we are running 8.1.4 (which is the correct
version).
[EMAIL PROTECTED] bin]$ pg_config --version
PostgreSQL 7.3.6-RH
[EMAIL PROTECTED] bin]$ which postmaster
~/bin/postmaster
[EMAIL
their forum on sf seems inactive, so i ask in this group to see if
anyone know the status
Q. is OpenFTS dead ? or the current beta is alreay mature enough to be
used in production?
FTS will get more and more important for a DBMS system, i think pgsql
should also consider improving this, isn't?
I'm inserting data into two tables, the second table has a forigen key that
points to the primary key of the first table.
After I insert a row into the first table, I need to take the primary key
value created in SERIAL column and store it so I can insert it as the
forigen key value on the
I think I found the answer, you use the CURRVAL() function.
Just to cover all the bases, consider this scenario in chronological order:
1. You insert data and the primary key is set to 20.
2. Someone else inserts data and the next key is set to 21.
3. If you call currval() will it return 20?
I think I found the answer, you use the CURRVAL() function.
Just to cover all the bases, consider this scenario in chronological order:
1. You insert data and the primary key is set to 20.
2. Someone else inserts data and the next key is set to 21.
3. If you call currval() will it return
On Jul 8, 2006, at 9:57 , [EMAIL PROTECTED] wrote:
FTS will get more and more important for a DBMS system, i think pgsql
should also consider improving this, isn't?
I believe a very common FTS solution used with PostgreSQL is
tsearch2, which is included in contrib/. Have you looked at
11 matches
Mail list logo