functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
'AY8510439' -- where the last digit is
^ ^ -- lowest AND highest
expected value
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMA
atic/sql-vacuum.html
http://www.postgresql.org/docs/8.2/static/sql-analyze.html
http://www.postgresql.org/docs/8.2/static/routine-vacuuming.html
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ld have.
(3) And this probably will not change soon since the OLE DB driver is not
actively supported.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
--- Stephen Frost <[EMAIL PROTECTED]> wrote:
> (perhaps a
> pastebin like http://pgsql.privatepaste.com) instead of or in addition
> to sending it in the email.
It this new? I don't remember seeing this used before.
Regards,
Richard Broersma Jr.
> I'd like to get more info on EXPLAIN ANALYZE output... where can I read more
> about it?
I believe this link has what you are looking for:
http://www.postgresql.org/docs/8.1/interactive/performance-tips.html
Regards,
Richard Broersma Jr.
---(end o
> > raid 10 is of course not questionable. but are you sure that it will
> > work faster than for example:
> > 2 discs (raid 1) for xlog
> > 6 discs (raid 10) for tables
> > 6 discs (raid 10) for indices?
> >
>
> This depends on your application. Do you have a lot of disc reads?
> Anyhow, I woul
here are additional limitations beyond these I would be interested in
knowing about them and
adding them to the http://www.postgresql.org/about/ we be helpful also.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked o
emory
and reduces that time it takes to scan the index.
Thats how I understand it.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
27;s up? This seems to
> be a new
> phenomenon. Should the [EMAIL PROTECTED] be getting these and discarding
> them?
>
> Thanks,
> Craig
Does the message come from postgresql.org or is the bounced email coming from
these specific users
when you include them in reply-all?
Regards,
Ri
> >This is an automatically generated Delivery Status Notification.
> >Delivery to the following recipients failed.
> > [EMAIL PROTECTED]
yes, I got the same thing that you did here. only i got when I replied all to
your email. Are you
sure this individual wasn't listed in any of y
so shmall may need to be adjusted also.
> The total RAM available on this machine is 512MB.
>
> I am not sure how to set these parameters SHMMAX and SHMMIN.
> Any help/advice would be greatly appreciated.
http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html
es to tune kernel parameters to maximized
usage of system
resources and at the same time allow for harmonious sharing between various
programs/services.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
since some of the
most affective parameters are non-run-time tune-able.
In regards to query planning, I wonder if there is way to model a controller
that could
adjust/alter query plans based on a comparison of expected and actual query
execution times.
Regards,
Richard Broersma Jr.
a
science, since most recommendations boil down to experiences based on trial and
error.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
15 matches
Mail list logo
