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
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
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
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" <[
> 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/
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
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
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.
--
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
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
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
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 --
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
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
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
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
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
17 matches
Mail list logo
