As a workaround,
you can run this in psql :
select
'grant select on ' || tablename || ' to ' || 'smith ;' from pg_tables
where schemaname='public';
The above SQL will
generate the DDL for all the tables in the schema "public" for
instance.
You may want to
direct your output
Sorry for noise. It turns out that little pound sign in front bit me !!
#autovacuum = onTom Lane <[EMAIL PROTECTED]> wrote:
Stephen Byers <[EMAIL PROTECTED]>writes:> Will autovacuum eventually run on this tableUm ... is autovacuum actually turned on? (It's not by default.)Check the pg_stat_ vi
On Nov 8, 2005, at 3:07 AM, Martin Schievink wrote: We’re having problems restoring a database, we dumped and tried to restore on the same databaseserver., and used the command: pg_dump -Ft -b {dbname} > {filename} to dump the database and pg_restore -d {dbname} {filename} to restore the database
On 11/11/05, Stephen Byers <[EMAIL PROTECTED]> wrote:
> I am using new postgres 8.1 and also trying out the integrated autovacuum.
> I have a concern.
>
> I have a table where I perform an update on a row every 10 seconds. The
> table is VERY small. Hardly any INSERTS, no DELETES, and a ton of UP
Stephen Byers <[EMAIL PROTECTED]> writes:
> Will autovacuum eventually run on this table
Um ... is autovacuum actually turned on? (It's not by default.)
Check the pg_stat_ views to see if the updates are getting counted in
the statistics for the table.
regards, tom l
I am using new postgres 8.1 and also trying out the integrated autovacuum. I have a concern.
I have a table where I perform an update on a row every 10 seconds. The table is VERY small. Hardly any INSERTS, no DELETES, and a ton of UPDATES.
adbs_db=# select count(*) from volumes; count --
Tom Lane napisał(a):
Marcin Giedz <[EMAIL PROTECTED]> writes:
However I still can see 'spikey' performance but not as much as before
changes. What can I do more to eliminate or smooth these spikes?
The spikes are certainly caused by checkpoints. You can fool with the
checkpoint
Marcin Giedz <[EMAIL PROTECTED]> writes:
> However I still can see 'spikey' performance but not as much as before
> changes. What can I do more to eliminate or smooth these spikes?
The spikes are certainly caused by checkpoints. You can fool with the
checkpoint timing via checkpoint_segment
Hello,
First of all: many thanks Tom for pointed me out what I made wrong and
Jim for 'spikes'.
I made some new tests:
available at http://85.128.68.44
What have changed since last time:
- database engine - now it's 8.1.0
- number of clients - "-c 20 "
- number of transactions - "-t
Josh O'Brien wrote:
Hello all
I was just wondering if anyone could tell me if there is any seamless
way to upgrade from 7.4 to 8.1 without performing a full dump/restore.
Slony-I or Mammoth Replicator
Thanks
Joshua O'Brien
DBA
Zedx Inc.
--
On Fri, Nov 11, 2005 at 11:08:58 -0500,
Josh O'Brien <[EMAIL PROTECTED]> wrote:
> Hello all
>
> I was just wondering if anyone could tell me if there is any seamless
> way to upgrade from 7.4 to 8.1 without performing a full dump/restore.
If you need to minimize down time, there are ways to us
Hello all
I was just wondering if anyone could tell me if there is any seamless
way to upgrade from 7.4 to 8.1 without performing a full dump/restore.
Thanks
Joshua O'Brien
DBA
Zedx Inc.
begin:vcard
fn:Joshua O'Brien
n:O'Brien;Joshua
org:Zedx Inc.
title:Database Administrator
version:2.1
end:v
> I am using C.
Lucky you. I use Python. ;)
> Yes i mean to allocate memory of each tuple resulting from a query.
> Is there any function which gives the size of a tuple?
> If so...Please tell me/Tell me how to proceed to do that?
From the manual:
http://www.postgresql.org/docs/8.0/interactive/
Hi John ,
Thank you.
I am using C.
Yes i mean to allocate memory of each tuple resulting from a query.
Is there any function which gives the size of a tuple?
If so...Please tell me/Tell me how to proceed to do that?
Thanks&Regards,
Sandhya R
- Original Message -
From: "John Barham" <[
On 11/11/05, sandhya <[EMAIL PROTECTED]> wrote:
> please...tell me if there is possibility of finding out the size of a
> record in the specified table.
> Is there any built in function to know the size of each record by passing a
> query?
> I need this Inorder to allocate the memory after retriev
please...tell me if there is possibility of
finding out the size of a record in the specified table.
Is there any built in function to know the
size of each record by passing a query?
I need this Inorder to allocate the memory after
retrieving the records.
Pls suggest me.
Thanks&Regard
Hello
I have configured the postgresql with SSL support enabled. Now from pg_hba.conf file I cofigured some host with SSL support using 'hostssl' and some host with out ssl i.e using 'host'. How do I come to know that a particular host is connected with SSL support or regularaly connected ? Tha
17 matches
Mail list logo
