Re: [SQL] query optimazation & starting postmaster with -B option

As I've found through countless trial and error and many emails to this list, performance is mostly in how you structure queries and how you use the backend (indexes, proper VACUUMing etc etc).. Increasing the size passed as -S and -B options will help -- there is probably much more that can be d

Re: [SQL] create function - user permissions

Markus Wagner wrote: > Hi, > > one of my users wants to create functions using the C language, but pgs > says "no permission". > > How can I permit the user to do this, while avoiding to give him root > access rights? Assuming with "root" access you mean "DB-superuser" rights. No way!

Re: [SQL] Why do I need to set UPDATE permissions for fkey check?

Jon Lapham wrote: > On Fri, Jul 21, 2000 at 02:00:00PM -0700, Stephan Szabo wrote: > > > > It's a known problem in the foreign key code. The reason is that > > the fk triggers use SELECT FOR UPDATE to select the matching > > rows that it is checking and the reason for using FOR UPDATE is > > to l

[SQL] query optimazation & starting postmaster with -B option

hai, Q 1 : Posgresql is running on Linux machine with 512MB ram. My question is When i start the postmaster with -B 3000 then there is no problem. If the start the postmaster with more than the 3000 then errors msg is popped out. How do I increase this buffer option morethan 3000 and wh