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