Marc Cousin wrote:
> Hi,
>
> I'm currently working with bacula developpers in order to improve performance
> (mainly for postgresql).
>
> In order for our new code to work, we need to be sure that libpq is threaded.
> For 8.2, we can use PQisthreadsafe();. The problem is we cannot force all
> u
Chris Hoover wrote:
I am doing some research into partitioning my postgres database.
While doing this, I am trying to take the opportunity to improve the
over all database.design. One of the things I am thinking of
implementing would be the use of nullif/coalesce. Our application
tends to s
Hi,
I'm currently working with bacula developpers in order to improve performance
(mainly for postgresql).
In order for our new code to work, we need to be sure that libpq is threaded.
For 8.2, we can use PQisthreadsafe();. The problem is we cannot force all
users to migrate to 8.2, and that ma
Charles.Hou wrote:
> how can i know that it's the time to vacuumdb? i set the crontab to
> vacuumdb 3 times in one day. because my database size increase from
> 440MB to 460MB in 8 hours.
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading thro
I am doing some research into partitioning my postgres database. While
doing this, I am trying to take the opportunity to improve the over all
database.design. One of the things I am thinking of implementing would be
the use of nullif/coalesce. Our application tends to send a lot of strings
tha
Hai dear,
I am Vijesh T.V. From Kerala India. Working as assistant
programmer, creating web applications using PHP4 and PostgreSQL as
database. But the platform is Linux. I have prepared a writeup to
install Apache, PostgreSQL,PHP in Linux. If You are interested please
mail me.
--
On Tue, 2007-06-05 at 03:33 -0700, Charles.Hou wrote:
> how can i know that it's the time to vacuumdb? i set the crontab to
> vacuumdb 3 times in one day. because my database size increase from
> 440MB to 460MB in 8 hours.
Have you looked at autovaccum? It can handle this for you.
If not, you ne
On Tue, Jun 05, 2007 at 03:33:09AM -0700, Charles.Hou wrote:
> how can i know that it's the time to vacuumdb? i set the crontab to
> vacuumdb 3 times in one day. because my database size increase from
> 440MB to 460MB in 8 hours.
You haven't told us enough. What's the churn on the database, to
be
i guess this what you meant:
(not a nice solution though) writing a function that returns the set
would be a better idea
create table testintarr (iarr int[]);
insert into testintarr values ('5,6,7,8');
test=# select iarr[idx] from (select iarr, generate_series(array_lower
(iarr,1), array_upp
Charles.Hou wrote:
> On 6 4 , 10 49 , [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> > It is normal that the tables grow a bit to a stationary state of dead
> > space (generated by UPDATE and DELETE). However it is not normal if it
> > loses track of that dead space. One thing you can and should
how can i know that it's the time to vacuumdb? i set the crontab to
vacuumdb 3 times in one day. because my database size increase from
440MB to 460MB in 8 hours.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appr
On 6 4 , 10 49 , [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> Charles.Hou wrote:
> > i set the auto vacuum option to enable. but my database size(hard-
> > disk
> > space) still increased from 420MB to 440MB in 8 hours. most of the
> > operations in this database are the "Select" query command, ju
12 matches
Mail list logo
