Hi All
Where do I find the Debian apt-get source path for
PostgreSQL 8.1
Regards,
Riaan van der Westhuizen
am 09.11.2005, um 9:00:08 +0200 mailte Riaan van der Westhuizen folgendes:
> Hi All
>
>
>
> Where do I find the Debian apt-get source path for PostgreSQL 8.1
deb http://people.debian.org/~mpitt/packages/sarge-backports/ /
8.1 on my sarge is running ;-)
[EMAIL PROTECTED]:~$ echo "selec
> Well, for starters, see if PostgreSQL is currently using any indexes via
> EXPLAIN. First rule of performance tuning: don't.
I'm designing a new application. Data is not available yet.
I'm using Postgres 8.1 in Windows. Database encoding is UTF-8
lc_ctype is Estonian_Estonia.1257.
lc_collate is
On Wed, Nov 09, 2005 at 12:37:25PM +0200, Andrus wrote:
> I'm using Postgres 8.1 in Windows. Database encoding is UTF-8
> lc_ctype is Estonian_Estonia.1257.
> lc_collate is Estonian currently. However I can set lc_collate to C if this
> solves this issue.
>
> Doc says that
> " to allow PostgreSQ
hi,
is there in postgres anything similar to:
insert on duplicate update?
here is the problem i need a solution for:
I need to insert in pg_type a row which was previously selected from there
and
with slight modifications, the problem is that when i try to insert the row
there might be a r
Peter Filipov wrote:
hi,
is there in postgres anything similar to:
insert on duplicate update?
here is the problem i need a solution for:
I need to insert in pg_type a row which was previously selected from
there and
with slight modifications, the problem is that when i try to insert the
On Wed, Nov 09, 2005 at 01:31:59PM +0200, Peter Filipov wrote:
> hi,
> is there in postgres anything similar to:
> insert on duplicate update?
> here is the problem i need a solution for:
> I need to insert in pg_type a row which was previously selected from there
> and
What's wrong with
Tom Lane writes:
> Jerry LeVan <[EMAIL PROTECTED]> writes:
>> I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing
>> "bad" I have noticed is that whenever I quit psql I get a message:
>> could not save history to file "/Users/jerry/.psql_history": Invalid
>> argument
>> This is
I have lost the superuser (user postgres) password, but I still have
the unix root password. Is there anything I can do to reset the
postgres user's password (short of reinstalling Postgres)?
Obviously, I can su to unix user postgres, but this does not seem to
advance my cause, as doing "psql -U p
Tom was right, on the Mac libreadline is linked to libedit.
My "solution" was to comment out the line reporting the
error in the program "input.c"
Jerry
On Nov 9, 2005, at 7:27 AM, Andreas Seltenreich wrote:
Tom Lane writes:
Jerry LeVan <[EMAIL PROTECTED]> writes:
I just upgraded from 8.0.4
On Wed, Nov 09, 2005 at 04:42:39AM -0800, mad wrote:
> I have lost the superuser (user postgres) password, but I still have
> the unix root password. Is there anything I can do to reset the
> postgres user's password (short of reinstalling Postgres)?
Edit pg_hba.conf to let you in without a passwo
The PostgreSQL docs say that "Temporary tables are automatically
dropped at the end of a session, or optionally at the end of the
current transaction." If I create a temporary table through a
java.sql.Statement and then call close() on that Statement, will the
temporary table be dropped? In other w
Hello,
I would like to know how to liste the contain of a fonction.
Writing \df in psql, I have a list of functions and triggers, but and
don't know how to obtain the code of those functions.
Thanks.
C. Tobini
---(end of broadcast)---
TIP 3: Hav
Hello everyone,
I reboot my machine while postmaster
is up.
after the m/c gets rebooted ,
I grep for the process "postmaster", and it does
not find it.
So, I try starting postmaster. and it
displays the following error message:
HINT: If you're sure there are no old server
processes stil
After looking at "Chapter 22. Routine Database Maintenance Tasks"
(http://www.postgresql.org/docs/8.1/interactive/maintenance.html), I
started wondering about what (if any) consideration to give to to
VACUUM issues in the following context.
As a background, I'll be using Postgres in part as a proc
Hi everyone,
I've just upgraded from Postgres 8.0.1 to 8.1. For testing purposes I'm
using a MS Access Frontend connected by ODBC. This worked fine until I
switched to the new ODBC-Driver (the Unicode-version). When I try to
connect to some new tables, the ODBC-Driver shows tables from the
informa
Use \df+ instead of \df
The additional "+" will give more details in many of the \ commands.
Cheers,
Csaba.
On Wed, 2005-11-09 at 14:40, ctobini wrote:
> Hello,
>
> I would like to know how to liste the contain of a fonction.
>
> Writing \df in psql, I have a list of functions and triggers, but
Hi,
have just a general question...
I have a table of 10M records, unique key on 5 fields.
I need to update/insert 200k records in one go.
I could do a select to check for existence and then either insert or update.
Or simply insert, check on the error code an update if required.
The 2nd seems
ctobini wrote:
Hello,
I would like to know how to liste the contain of a fonction.
Writing \df in psql, I have a list of functions and triggers, but and
don't know how to obtain the code of those functions.
Start psql with -E and you'll see how all the backslash \d? commands work.
--
Rich
surabhi.ahuja wrote:
Hello everyone,
I reboot my machine while postmaster is up.
after the m/c gets rebooted , I grep for the process "postmaster",
and it does not find it.
So, I try starting postmaster. and it displays the following error
message: HINT: If you're sure there are no old serve
am 09.11.2005, um 5:40:14 -0800 mailte ctobini folgendes:
> Hello,
>
> I would like to know how to liste the contain of a fonction.
You can find this in information_schema.routines.
>
> Writing \df in psql, I have a list of functions and triggers, but and
> don't know how to obtain the code
Orhan wrote:
The PostgreSQL docs say that "Temporary tables are automatically
dropped at the end of a session, or optionally at the end of the
current transaction." If I create a temporary table through a
java.sql.Statement and then call close() on that Statement, will the
temporary table be drop
[EMAIL PROTECTED] wrote:
After looking at "Chapter 22. Routine Database Maintenance Tasks"
(http://www.postgresql.org/docs/8.1/interactive/maintenance.html), I
started wondering about what (if any) consideration to give to to
VACUUM issues in the following context.
As a background, I'll be using
I guess the best solution is one which allows you to do it in batches,
as inserting is more efficient if you don't commit after each insert.
On Wed, 2005-11-09 at 15:45, Alex wrote:
> Hi,
> have just a general question...
>
> I have a table of 10M records, unique key on 5 fields.
> I need to upda
Richard Huxton writes:
> Peter Filipov wrote:
>> is there in postgres anything similar to:
>> insert on duplicate update?
>> here is the problem i need a solution for:
>> I need to insert in pg_type a row which was previously selected from
>> there and
>> with slight modifications, the prob
am 10.11.2005, um 1:45:46 +1100 mailte Alex folgendes:
> Hi,
> have just a general question...
>
> I have a table of 10M records, unique key on 5 fields.
> I need to update/insert 200k records in one go.
>
> I could do a select to check for existence and then either insert or
> update.
> Or si
Quoting Tom Lane <[EMAIL PROTECTED]>:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
> > This might have been discussed before but I wanted to know if clustering
> tables
> > by partial indexes will be availble in a later release of pgSQL?
>
> What in the world would it mean to do that?
I'm not
I have a file which is a long series of SQL commands. Creating
tables, copying in data, indexing, munging the data, intermittently
vacuuming to keep things moving.
I have usually run this big script like this:
nohup psql dbname < script.sql &
After upgrading to 8.0, the script to slow to a craw
Quote from the link below:
"Tip: A block containing an EXCEPTION clause is significantly more
expensive to enter and exit than a block without one. Therefore, don't
use EXCEPTION without need."
I would think this places an automatic save-point at the begin of the
block. I doubt this would give t
Thanks a lot man!!! You saved my life :P
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Martes, 08 de Noviembre de 2005 04:13 p.m.
To: Cristian Prieto
Cc: pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [GENERAL] [HA
"Keith C. Perry" <[EMAIL PROTECTED]> writes:
> Quoting Tom Lane <[EMAIL PROTECTED]>:
>> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
>>> This might have been discussed before but I wanted to know if clustering
>>> tables by partial indexes will be availble in a later release of pgSQL?
>>
>> What i
Richard Huxton writes:
> surabhi.ahuja wrote:
>> So, I try starting postmaster. and it displays the following error
>> message: HINT: If you're sure there are no old server processes
>> still running, remove the shared memory block with the command "ipcr
>> m", or just delete the file
>> "/expo
Yes it is exactly that. I will follow you advice and create a abstraction layer for the data access that will return the sparse dataset using the standard dataset as input.
There is just one thing I disagree you said it that the performance is not good, right. However, it is practical! Nothing is
Ian Harding <[EMAIL PROTECTED]> writes:
> That being the case, what could be causing my script to slow to a
> crawl when redirected to psql, but run fine from inside psql with -i?
Readline issue maybe? Please try this way
psql -f script.sql
as well as the stdin way; then try both with -n
You absolutely should NOT I repeat NOT -- DON'T dink around with the system
catalogs in ANY database... If you need to create UDT's then you should
follow the proper mechanisms to create your own user-defined types...
""Peter Filipov"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECT
Evandro's mailing lists (Please, don't send personal messages to this
address) schrieb:
Yes it is exactly that. I will follow you advice and create a
abstraction layer for the data access that will return the sparse
dataset using the standard dataset as input.
There is just one thing I disagre
In article <[EMAIL PROTECTED]>,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> As a background, I'll be using Postgres in part as a processing queue
> for a 40-column stream of information (~ 250 bytes/row) with a
> sustained input rate of 20 rows/sec. This queue will be processed
> periodicall
I was wondering if somebody could point me in the right direction.
I'm situated in Brazil and recently daylights savings/summer time kicked in and clocks were set one hour ahead. Now on my windows box the system clock automatically adjusted to the correct time. But performing the following query o
I would unix su, edit pg_hba.conf to allow open access
temporarily, connect to pg and change the posgres password.
Don't forget to change pg_hba.conf back again to password
protect the db!
TJ
I have lost the superuser (user postgres) password, but I still have
the unix root password. Is there
On Wed, Nov 09, 2005 at 02:24:28PM -0200, Giovanni M. wrote:
> I'm situated in Brazil and recently daylights savings/summer time kicked in
> and clocks were set one hour ahead. Now on my windows box the system clock
> automatically adjusted to the correct time. But performing the following
> query
I just set up a new server and would like to use rpms to manage the
software on this one. I've done the compile from source thing
most of the time, but over time it seems to get messy.
I'm using CentOS 4.2, which only has packages for postgres 7.4, but I
very much want to use 8.1. I installed th
The following transfers the serial number of fluid_id into the two
tables, specification and pipe.
However, it doesn't follow the WHERE instruction. All fluid_id serial
numbers in process are transferred to fluid_id column in pipe with no
discrimination.
I can't see what I have done wrong
I like the new bitmap scans and I'm wondering if there is any way
I can utilize them for my bitmask column, defined as bit(1024).
I use this column as a sort of fingerprint to quickly scan my tables.
But it is a scan, not an index. I have not figured out a way to
index the bitmask column. Is the
Can anyone explain why the first one never completes, but the second one does?
(the first one just keeps running, I canceled after ~1 min)
PG version: 8.1 final
-- tblname param has type varchar
create or replace function getcolstring (tblname varchar) returns varchar as $$
declare
table_col
On Wed, Nov 09, 2005 at 10:06:06AM -0800, Bob Pawley wrote:
> The following transfers the serial number of fluid_id into the two
> tables, specification and pipe.
>
> However, it doesn't follow the WHERE instruction. All fluid_id serial
> numbers in process are transferred to fluid_id column in pi
On Wed, 9 Nov 2005, TJ O'Donnell wrote:
I like the new bitmap scans and I'm wondering if there is any way
I can utilize them for my bitmask column, defined as bit(1024).
I use this column as a sort of fingerprint to quickly scan my tables.
But it is a scan, not an index. I have not figured out
I need to log table "foo" real deletes.
"foo" has foreign key relation established but no data exists.
Postgres 8.1 calls "foo" delete trigger when record is deleted from master
table "klient". Why ?
How to modify the following code so that record is inserted into serveri
table only when record
On Wed, Nov 09, 2005 at 10:18:35AM -0800, TJ O'Donnell wrote:
> I like the new bitmap scans and I'm wondering if there is any way
> I can utilize them for my bitmask column, defined as bit(1024).
> I use this column as a sort of fingerprint to quickly scan my tables.
> But it is a scan, not an inde
On Wed, Nov 09, 2005 at 07:38:53PM +0100, Mikael Carneholm wrote:
> Can anyone explain why the first one never completes, but the second
> one does? (the first one just keeps running, I canceled after ~1 min)
>
> PG version: 8.1 final
Both functions create fine here in 8.1.0 on FreeBSD 6.0/i386 an
"Mikael Carneholm" <[EMAIL PROTECTED]> writes:
> Can anyone explain why the first one never completes, but the second
> one does?
They both work fine for me ...
regards, tom lane
---(end of broadcast)---
TIP 1: if posting/re
"Andrus" <[EMAIL PROTECTED]> writes:
> Postgres 8.1 calls "foo" delete trigger when record is deleted from master
> table "klient". Why ?
Because you have an ON DELETE CASCADE. That leads to a DELETE ... WHERE ...
on the slave table; whether any records actually get deleted depends on
what the D
Postgres machine OS: RHEL release 2.1 (Panama)
PGAdminIII client OS: WinXP Pro 2002 SP2
Clients: psql, PGAdminIII Query tool
dfol=> select version();
version
-
PostgreSQL 8.1.0 on i68
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 9 Nov 2005, Brian Mathis wrote:
I'm using CentOS 4.2, which only has packages for postgres 7.4, but I very
much want to use 8.1. I installed the 8.1 RPMs, but when I try to install
packages like perl-DBD-Pg, or php-pgsql, rpm complains
On 11/9/05 9:45 AM, "Alex" <[EMAIL PROTECTED]> wrote:
> Hi,
> have just a general question...
>
> I have a table of 10M records, unique key on 5 fields.
> I need to update/insert 200k records in one go.
>
> I could do a select to check for existence and then either insert or update.
> Or simply
Martijn,
>> I can use queries:
>>
>> WHERE col1 BETWEEN 'f' and 'f'+CHR(255)
>Well, you could do that in postgresql too, you just need to use the SQL
>standard concatination operator.
>WHERE col1 BETWEEN 'f' and 'f' || chr(255);
thank you.
I think it is best to use regular indexes since regula
Hello!
I am currently testdriving migration of our PostgreSQL 8.0 databases to 8.1; in
this process I have stumbled a couple of times over certain errors in
text-fields that lead to error-messages during import of the dump like these:
<2005-11-09 14:57:34 CET - 9354: [EMAIL PROTECTED]>ERROR: i
Andrus wrote:
So
CREATE INDEX i1 ON foo(col1);
cannot be used to optimize queries of type "get all rows where first n
charaters of col1 are known" in Postgres.
Of course it will! Any btree based index will let you do that. Re-read
the previous answers and make sure you pay attention to the
On 11/9/05, Andrus <[EMAIL PROTECTED]> wrote:
> Martijn,
>
> >> I can use queries:
> >>
> >> WHERE col1 BETWEEN 'f' and 'f'+CHR(255)
>
> >Well, you could do that in postgresql too, you just need to use the SQL
> >standard concatination operator.
>
> >WHERE col1 BETWEEN 'f' and 'f' || chr(255);
>
>
Thanks for that rpm.
I noticed that the x86_64 version of the compat libs installs the files
in /usr/lib, while the x86_64 postgresql-libs rpm uses
/usr/lib64. Is there are reason for that? Otherwise, I'd
prefer to keep all the 64bit libs in lib64.
On 11/9/05, Devrim GUNDUZ <[EMAIL PROTECTED]> w
I followed your instructions and now() indeed returned the correct time!
Thanks for your help
On 11/9/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Wed, Nov 09, 2005 at 02:24:28PM -0200, Giovanni M. wrote:> I'm situated in Brazil and recently daylights savings/summer time kicked in
> and clocks
> Because you have an ON DELETE CASCADE. That leads to a DELETE ... WHERE
> ...
> on the slave table; whether any records actually get deleted depends on
> what the DELETE finds. This is a general hazard of using STATEMENT
> triggers: you have no info about whether the statement actually did
> a
First rule of performance tuning: don't. See how well things run using
the simple plan you've drawn up. If performance is acceptable, you're
done.
Yes, you could keep the flag in a seperate table, but remember that
every row has a ~20 byte overhead, which is non-trivial. If you want to
go this rou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 9 Nov 2005, Brian Mathis wrote:
I noticed that the x86_64 version of the compat libs installs the files in
/usr/lib, while the x86_64 postgresql-libs rpm uses /usr/lib64. Is there are
reason for that? Otherwise, I'd prefer to keep all
> you can create two indexes:
>
> CREATE INDEX myindex_lc on mytable(col1 text_pattern_ops);
> and
> CREATE INDEX myindex_normal ON foo(col1);
>
> the first one will be used when using LIKE and the other for normal
> comparisons .
Jaime,
CREATE INDEX myindex_normal ON foo(col1);
Creates btree st
>> CREATE INDEX i1 ON foo(col1);
>>
>> cannot be used to optimize queries of type "get all rows where first n
>> charaters of col1 are known" in Postgres.
>
> Of course it will! Any btree based index will let you do that. Re-read the
> previous answers and make sure you pay attention to the bit a
On Wed, 2005-11-09 at 14:56, Andrus wrote:
> > you can create two indexes:
> >
> > CREATE INDEX myindex_lc on mytable(col1 text_pattern_ops);
> > and
> > CREATE INDEX myindex_normal ON foo(col1);
> >
> > the first one will be used when using LIKE and the other for normal
> > comparisons .
>
> Jaim
On Wed, Nov 09, 2005 at 10:46:27PM +0200, Andrus wrote:
> thank you. I try to formulate my problem more presicely.
> I have table
>
> CREATE TABLE foo ( bar CHAR(10) PRIMARY KEY);
>
> Cluster locale is non-C. Database encoding is UTF-8. Postgres vers is 8.1
Do this instead:
CREATE TABLE foo (
On 11/9/05, Andrus <[EMAIL PROTECTED]> wrote:
> > you can create two indexes:
> >
> > CREATE INDEX myindex_lc on mytable(col1 text_pattern_ops);
> > and
> > CREATE INDEX myindex_normal ON foo(col1);
> >
> > the first one will be used when using LIKE and the other for normal
> > comparisons .
>
> Ja
On 2005-11-09 13:08, Martijn van Oosterhout wrote:
I want to run fast queries by knowing first characters of bar like :
1. Select records from foo where first character of bar is A
2. Select records from foo where first character of bar is B
3. Select records from foo where first two characters
Brian Mathis wrote:
I just set up a new server and would like to use rpms to manage the
software on this one. I've done the compile from source thing most of
the time, but over time it seems to get messy.
I'm using CentOS 4.2, which only has packages for postgres 7.4, but I
very much want to
"Andrus" <[EMAIL PROTECTED]> writes:
> I tried following code:
> insert into klient values (1);
> update klient set kood=2 WHERE kood=3;
> In this case, foo_trig trigger is NOT executed.
Well, yes, because that UPDATE didn't change any rows of the master
table.
regards,
I just wanted to make sure this change in behavior is
a feature and not a bug.
This block of code with a (mis?)use of a set-valued function:
CREATE OR REPLACE FUNCTION foo() RETURNS SETOF varchar AS $$ {
my $res = [];
push @$res,'a';
push @$res,'b';
return $res;
} $$ LANGUAGE
My build of postgresql-8.1.0 is failing on MacOSX. Following the
INSTALL file, I passed configure flags for bonjour (what's that?) and
python support. i.e.:
./configure --with-bonjour --with-python
My invocation of make, launched from the postgres account, returns
the following errors
After playing with 1.4 for a bit I must say you've all out done
yourselves. This is a top quality release, from the refined UI to
the added support for Slony-I. Keep up the good work. Apps like
this move our community and the PostgreSQL project ahead, functional,
clean, and professional.
Scott,
>> I'm searching a way to use Postgres regular index for this.
>
> Easy, do what those other databases do. Setup your database to not use
> a locale.
>
> initdb --locale=C
>
> and you're golden.
thank you.
My language has letters in õäöüþð with correstonding upper case letters
ÕÄÖÜÞÐ
I
>> CREATE TABLE foo ( bar CHAR(10) PRIMARY KEY);
>>
>> Cluster locale is non-C. Database encoding is UTF-8. Postgres vers is 8.1
>Do this instead:
>CREATE TABLE foo ( bar CHAR(10) NOT NULL );
>CREATE UNIQUE INDEX foo_bar ON foo(bar char_pattern_ops);
Martijn,
Thank you. I have CHAR columns and
On Wed, 2005-11-09 at 15:30, Andrus wrote:
> Scott,
>
> >> I'm searching a way to use Postgres regular index for this.
> >
> > Easy, do what those other databases do. Setup your database to not use
> > a locale.
> >
> > initdb --locale=C
> >
> > and you're golden.
>
> thank you.
>
> My language
> SELECT * FROM foo WHERE bar::CHAR(1) = 'A';
> SELECT * FROM foo WHERE bar::CHAR(1) = 'B';
> SELECT * FROM foo WHERE bar::CHAR(2) = 'BC';
> SELECT * FROM foo WHERE bar::CHAR(3) = 'ABC';
Dean,
thank you. That would be EXCELLENT solution!
Can you confirm that in this case Postgres 8.1 can use in
[EMAIL PROTECTED] writes:
> I just wanted to make sure this change in behavior is
> a feature and not a bug.
Afraid so --- the plperl SRF support was rewritten in 8.1, and
it probably behaves just like plpgsql now, which has also got
this restriction.
> Is there an easy way of rewriting this cons
On 11/9/05, Andrus <[EMAIL PROTECTED]> wrote:
> >> CREATE TABLE foo ( bar CHAR(10) PRIMARY KEY);
> >>
> >> Cluster locale is non-C. Database encoding is UTF-8. Postgres vers is 8.1
>
> >Do this instead:
>
> >CREATE TABLE foo ( bar CHAR(10) NOT NULL );
> >CREATE UNIQUE INDEX foo_bar ON foo(bar char
Scott Frankel <[EMAIL PROTECTED]> writes:
> My build of postgresql-8.1.0 is failing on MacOSX.
> /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0)
> file: -lSystem is not an object file (not allowed in a library)
We've seen this before. IIRC, it means you're using outdated
On Wed, 2005-11-09 at 16:23, Jaime Casanova wrote:
> On 11/9/05, Andrus <[EMAIL PROTECTED]> wrote:
> > >> CREATE TABLE foo ( bar CHAR(10) PRIMARY KEY);
> > >>
> > >> Cluster locale is non-C. Database encoding is UTF-8. Postgres vers is 8.1
> >
> > >Do this instead:
> >
> > >CREATE TABLE foo ( bar
Claus Scherschel wrote:
I've just upgraded from Postgres 8.0.1 to 8.1. For testing purposes I'm
using a MS Access Frontend connected by ODBC. This worked fine until I
switched to the new ODBC-Driver (the Unicode-version). When I try to
connect to some new tables, the ODBC-Driver shows tables fro
Andrus wrote:
> > SELECT * FROM foo WHERE bar::CHAR(1) = 'A';
> > SELECT * FROM foo WHERE bar::CHAR(1) = 'B';
> > SELECT * FROM foo WHERE bar::CHAR(2) = 'BC';
> > SELECT * FROM foo WHERE bar::CHAR(3) = 'ABC';
> Can you confirm that in this case Postgres 8.1 can use index created
> by
> CREATE TABL
Will give that a try. thanks.
was actually interested if the 2nd approach is common practice or if
there are some reasons not to do it that way.
Alex
Sean Davis wrote:
On 11/9/05 9:45 AM, "Alex" <[EMAIL PROTECTED]> wrote:
Hi,
have just a general question...
I have a table of 10M record
Hi,
could anyone tell me if it is necessary to run a Vacuum after truncating
a table or is that done automatically.
Thanks
Alex
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Alex <[EMAIL PROTECTED]> writes:
> could anyone tell me if it is necessary to run a Vacuum after truncating
> a table or is that done automatically.
TRUNCATE does not require a vacuum; indeed there's nothing left *to* vacuum.
regards, tom lane
---
On Thu, Nov 10, 2005 at 01:16:24PM +1100, Alex wrote:
> could anyone tell me if it is necessary to run a Vacuum after truncating
> a table or is that done automatically.
http://www.postgresql.org/docs/8.0/interactive/maintenance.html#VACUUM-FOR-SPACE-RECOVERY
"If you have a table whose contents
88 matches
Mail list logo
