hi all,
I have a question :-
when we should consider vacuuming the table
is there an average dead_tuple_percent that should be taken into account before vacuuming any table ?. i have
rpt_production=# select * from pgstattuple('table1');-[ RECORD 1 ]--+--table_len | 105537
Hello All,
I run Tru64 Unix 5.1B / Alpha OSF1.
I have installed Postgresql 8.0.3 on a cluster.
The following is my pg_hba.conf,
"
hostdcs all 127.0.0.1 255.255.255.255
password
hostdcsconfig all 127.0.0.1 255.255.255.255
password
local all
Hi,
I'm running postgres on a Linux server SuSE SLES. When I run postgresql
8.0.3, I get /tmp/.s.PGSQLl.5432 socket open with group and owner
permissions. The group permissions are the default group of the postgres
account and the owner is postgres. If I want to start postgres with a
non-
Hello all,
I was justwondering if anyone is using continuents p/cluster and could
give me info on there personal experience. Thank you
begin:vcard
fn:Joshua O'Brien
n:O'Brien;Joshua
org:Zedx Inc.
title:Database Administrator
version:2.1
end:vcard
---(end of broadcast)-
"Dan The Man" <[EMAIL PROTECTED]> writes:
> I'm running postgres on a Linux server SuSE SLES. When I run postgresql
> 8.0.3, I get /tmp/.s.PGSQLl.5432 socket open with group and owner
> permissions. The group permissions are the default group of the postgres
> account and the owner is postgre
Hi,
I have a table with 400,000 records, but in delete comand is very slow
(4 seconds for operation)
Why is very slow? There is some special configuration for this?
Ps.: Version = Postgresql 7.4.6
Thanks
Diego Ziquinatti
---(end of broadcast)---
On Tue, 2005-11-29 at 18:13 -0300, Diego wrote:
> Hi,
> I have a table with 400,000 records, but in delete comand is very slow
> (4 seconds for operation)
> Why is very slow? There is some special configuration for this?
>
> Ps.: Version = Postgresql 7.4.6
That smells like a bad design. What do
Thanks by answers...
For each record deleted, my postgresql server spended 4 seconds...
I know because i have logged each sql instruction, showing the time spended.
My question is: is normal this time to a big table (400,000 records)
Thanks!
Diego Ziquinatti
From Brazil (excuse me my english, r
On Tue, 2005-11-29 at 15:32, Diego wrote:
> Thanks by answers...
>
> For each record deleted, my postgresql server spended 4 seconds...
> I know because i have logged each sql instruction, showing the time spended.
>
> My question is: is normal this time to a big table (400,000 records)
Do you h
!Hola LISTA!
La duda és :
Yo he hecho un pg_dump de una base de datos llamada
CHT
ex: pg_dump cht >
cht.backup
después hice un psql (restore) en otro servidor en
una base con el mismo nombre
ex: psql cht < cht.backup
Y tengo la mensage:
FATAL: IDENT authentication failed
for user
Can you provide the output of EXPLAIN ANALYZE for one of these deletes?
On Tue, Nov 29, 2005 at 06:32:43PM -0300, Diego wrote:
> Thanks by answers...
>
> For each record deleted, my postgresql server spended 4 seconds...
> I know because i have logged each sql instruction, showing the time spende
Hi,
I've been using postgresql v810 for a couple of weeks. I notice when I
start it up I get 'invalid lenth of startup packet' On a database that I
just initialized I get ' incomplete startup packet' after I first started
it. This never happened that I can see in 8.0.3.
Does any one know
A good idea would be to:
1) if your spanish is strong enough, post into the -es mailing list and kindly request for help there.
(Si tu espaniol es fuerte, escribi a la lista -es, te vas a encontrar mas comodo con las posibles respuestas)
2) if your spanish isn't strong enough, post here again,
I can notice:
< % %2005-11-28 07:31:10 EST>LOG: database system was not properly shutdown; automatic recovery in progress
At a first sight, you didn't shut down the database as expected. (pg_ctl stop -m smart/fast/immediate). Now I don't know if this is the root cause for that message, but a c
"Dan The Man" <[EMAIL PROTECTED]> writes:
> I've been using postgresql v810 for a couple of weeks. I notice when I
> start it up I get 'invalid lenth of startup packet' On a database that I
> just initialized I get ' incomplete startup packet' after I first started
> it. This never happened
On Thu, 2005-11-24 at 11:12 -0500, Colton Smith wrote:
> My question involves how the database performs the following queries:
>
> explain select max(measurement_date) from pressure;
> QUERY
> PLAN
>
I want to create a postgresql user with restricted permissions--all it
should be able to do is select on a few views that I specify.
So I did the following, as the database owner:
create user viewer password '';
grant select on myview to viewer;
Then, when I start psql as the viewer user, spe
Dan Tenenbaum <[EMAIL PROTECTED]> writes:
> ERROR: permission denied for schema myschema
> What do I need to do to get the correct permissions?
GRANT USAGE ON SCHEMA myschema TO whoever
Schema access is comparable to directory access in a filesystem: if you
can't look into the directory, it doesn
On Tue, Nov 29, 2005 at 03:30:33PM -0800, Dan Tenenbaum wrote:
> I want to create a postgresql user with restricted permissions--all it
> should be able to do is select on a few views that I specify.
>
> So I did the following, as the database owner:
> create user viewer password '';
> grant s
Thanks to both you and Jim--this was the missing piece that made things work.
On 11/29/05, Tom Lane <[EMAIL PROTECTED]> wrote:
Dan Tenenbaum <[EMAIL PROTECTED]> writes:> ERROR: permission denied for schema myschema> What do I need to do to get the correct permissions?GRANT USAGE ON SCHEMA myschema
20 matches
Mail list logo
