Hi,
We have a database of about 62000 tables (about 2000 tablespaces) with an
index on each table. Postgresql version is 8.1.
Although after the initial inserts to about 32000 tables the subsequent
inserts are considerable fast, subsequent inserts to more than 32000 tables
are very slow.
This se
Στις Monday 10 November 2008 16:18:37 ο/η Dilek Küçük έγραψε:
> Hi,
>
> We have a database of about 62000 tables (about 2000 tablespaces) with an
> index on each table. Postgresql version is 8.1.
>
So you have about 62000 distinct schemata in your db?
Imagine that the average enterprise has abou
Is there a query I can run against PostgreSQL to get the number of
current client connections to the database? I didn't expect trying to
track this down would be as difficult as it has been.
Would a simple count of pg_stat_activity be correct?
-Thanks
signature.asc
Description: This is a digita
"=?ISO-8859-1?Q?Dilek_K=FC=E7=FCk?=" <[EMAIL PROTECTED]> writes:
> We have a database of about 62000 tables (about 2000 tablespaces) with an
> index on each table. Postgresql version is 8.1.
You should probably rethink that schema. A lot of similar tables can be
folded into one table with an extr
Is it at all possible to get pgsql installed on a system without access
to a shell? A friend is wanting me to install a particular bulletin
board system on her website; however, her hosting plan only provides the
MySQL database - the bulletin board requires pgsql. And her hosting
plan has no
On Mon, Nov 10, 2008 at 09:50:09AM -0600, Dana Holland wrote:
> Is it at all possible to get pgsql installed on a system without access
> to a shell? A friend is wanting me to install a particular bulletin
> board system on her website; however, her hosting plan only provides the
> MySQL databa
On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
<[EMAIL PROTECTED]> wrote:
> Is it at all possible to get pgsql installed on a system without access to a
> shell? A friend is wanting me to install a particular bulletin board system
> on her website; however, her hosting plan only provides the MySQL
Yes, you got it. A count on pg_stat_activity should do it.
Regards,
Husam
-Original Message-
From: Sean Brown <[EMAIL PROTECTED]>
Sent: Monday, November 10, 2008 7:10 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Number of Current Client Connections
Is there a query I can run
Scott Marlowe schrieb:
On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
<[EMAIL PROTECTED]> wrote:
Is it at all possible to get pgsql installed on a system without access to a
shell? A friend is wanting me to install a particular bulletin board system
on her website; however, her hosting plan only
gmake install requires root privileges.
It wont install with regular httpd user (apache, nobody etc.) on a php-shell
script or php system command functions.
On Mon, Nov 10, 2008 at 10:08 AM, Thomas Pundt <[EMAIL PROTECTED]> wrote:
> Scott Marlowe schrieb:
>
>> On Mon, Nov 10, 2008 at 8:50 AM, Da
You do NOT have to have root priviledges. I've built postgresql more
than once without it and made it work.
What you do need is to install it to your local home directory where
the apache user has priviledges and set LD_LIBRARY_PATH (or whatever
it's called, it has been a while) and you're golden
On Mon, Nov 10, 2008 at 10:54:57AM -0700, Scott Marlowe wrote:
> > Is it at all possible to get pgsql installed on a system without access to a
> > shell? A friend is wanting me to install a particular bulletin board system
> > on her website; however, her hosting plan only provides the MySQL dat
12 matches
Mail list logo
