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
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
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
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
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
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
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.
--
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
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
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
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
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
12 matches
Mail list logo
