Yes, you're right ! The process checks if all these tables exist before
creating them. So it might be the SELECT that takes time. To check existence, I
use the following query :
select * from pg_tables where tablename='the_table';
May be it's not the best way. And I launch a query per table ! N
On Sun, Jul 8, 2012 at 11:49 PM, Sylvain CAILLET wrote:
> Hi,
>
> Thank you all for your help.
>
> @Jeff : my daemon creates these tables at start time so it doesn't do
> anything else at the same time. The CPU is loaded between 20% and 25%.
How does it decide which tables to create? Is it query
Hi,
Thank you all for your help.
@Jeff : my daemon creates these tables at start time so it doesn't do anything
else at the same time. The CPU is loaded between 20% and 25%.
@Richard : Sure the DB number of table is quite big and sure most of them have
the same structure, but it's very har
On 07/06/2012 11:15 PM, Sylvain CAILLET wrote:
Hi to all,
I run Postgresql 8.3.9 on a dedicated server running with Debian
5.0.4, a strong bi quad-proc with RAM 16Go. My biggest db contains at
least 100 000 tables. Last time, I started a Java process I use to
make some change on it, it create
On 06/07/12 16:15, Sylvain CAILLET wrote:
Hi to all,
I run Postgresql 8.3.9 on a dedicated server running with Debian 5.0.4,
a strong bi quad-proc with RAM 16Go. My biggest db contains at least 100
000 tables.
That is a *lot* of tables and it's probably going to be slow whatever
you do.
La
On Fri, Jul 6, 2012 at 8:15 AM, Sylvain CAILLET wrote:
> Hi to all,
>
> I run Postgresql 8.3.9 on a dedicated server running with Debian 5.0.4, a
> strong bi quad-proc with RAM 16Go. My biggest db contains at least 100 000
> tables. Last time, I started a Java process I use to make some change on
Hi to all,
I run Postgresql 8.3.9 on a dedicated server running with Debian 5.0.4, a
strong bi quad-proc with RAM 16Go. My biggest db contains at least 100 000
tables. Last time, I started a Java process I use to make some change on it, it
created 170 new tables and it took one full minute.
