Thread: Postgresql.org website search
I apologise if this has been posted/asked already, but since it has been about a week and it hasn't been "fixed" I needed to ask. Every time I issue a search at http://www.postgresql.org/search.mpl even on the easiest of search items, such as "postgres" I get a result of this, and only this: Search results: postgres : 33688 Displaying documents 0-0 of total 33688 found. (0.00 secs) Now it still seems to take its sweet time to search so it seems like the search is working, just no results are actually getting displayed. Has anyone else noticed this? Does it just not like me? Thanks.
That search feature regularly breaks. That's about all I can say. [ Charset ISO-8859-1 unsupported, converting... ] > I apologise if this has been posted/asked already, but since it has been > about a week and it hasn't been "fixed" I needed to ask. Every time I > issue a search at http://www.postgresql.org/search.mpl even on the > easiest of search items, such as "postgres" I get a result of this, and > only this: > > Search results: postgres : 33688 > > Displaying documents 0-0 of total 33688 found. (0.00 secs) > > Now it still seems to take its sweet time to search so it seems like the > search is working, just no results are actually getting displayed. > > Has anyone else noticed this? Does it just not like me? > > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Why could the site not use something like http://www.freefind.com/ to do searches on the site? Sam -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Bruce Momjian Sent: Friday, March 09, 2001 10:59 AM To: Tim Frank Cc: pgsql-general@postgresql.org; PostgreSQL Webmaster Subject: Re: Postgresql.org website search That search feature regularly breaks. That's about all I can say. [ Charset ISO-8859-1 unsupported, converting... ] > I apologise if this has been posted/asked already, but since it has been > about a week and it hasn't been "fixed" I needed to ask. Every time I > issue a search at http://www.postgresql.org/search.mpl even on the > easiest of search items, such as "postgres" I get a result of this, and > only this: > > Search results: postgres : 33688 > > Displaying documents 0-0 of total 33688 found. (0.00 secs) > > Now it still seems to take its sweet time to search so it seems like the > search is working, just no results are actually getting displayed. > > Has anyone else noticed this? Does it just not like me? > > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Shop online without a credit card http://www.rocketcash.com RocketCash, a NetZero subsidiary
Tim Frank writes: > I apologise if this has been posted/asked already, but since it has been > about a week and it hasn't been "fixed" I needed to ask. Every time I > issue a search at http://www.postgresql.org/search.mpl even on the > easiest of search items, such as "postgres" I get a result of this, and > only this: > > Search results: postgres : 33688 > > Displaying documents 0-0 of total 33688 found. (0.00 secs) http://www.geocrawler.com/lists/3/Databases/ -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
Hi all, I was wondering what the typical memory requirments were for the postgresql server ? Thanks.
Hi I don't think there is any typical memory requirment. People usually give PostgreSQL a lot of memory to get better performance. Ideally the amount of memory is the same as the amount of data your storing in your database. This way PostgreSQL can cache all the data and never have to read data from the disk. But this scenario assumes that you have mostly SELECT queries. You have to remember to set the -B flag on postmaster to set the shared-memory size. HTH, Poul L. Christiansen Simon Crute wrote: > > Hi all, > I was wondering what the typical memory requirments were for the > postgresql server ? > > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> But this scenario assumes that you have mostly SELECT queries. > > You have to remember to set the -B flag on postmaster to set the > shared-memory size. Any recommended values for -B, assuming a mostly-SELECT environment? John -- # John Madden weez@freelists.org ICQ: 2EB9EA # FreeLists, Free mailing lists for all: http://www.freelists.org # UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us # Linux, Apache, Perl and C: All the best things in life are free!
The -B value is a a multiple of BLCKSZ, which is 8KB by default. I would recommend using all availabe memory if it's a PostgreSQL standalone box. If your box has 256MB memory set the -B value to 200MB/8KB = 25600. Then the OS will have 56MB. For a well configured Linux box, this should be enough. Remember to adjust the maximum shared memory value. On my Redhat Linux 7.0 box the vale is set in /proc/sys/kernel/shmmax. This question has emerged more than once. Shouldn't we put it in the FAQ? Poul L. Christiansen John Madden wrote: > > > But this scenario assumes that you have mostly SELECT queries. > > > > You have to remember to set the -B flag on postmaster to set the > > shared-memory size. > > Any recommended values for -B, assuming a mostly-SELECT environment? > > John > > -- > # John Madden weez@freelists.org ICQ: 2EB9EA > # FreeLists, Free mailing lists for all: http://www.freelists.org > # UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us > # Linux, Apache, Perl and C: All the best things in life are free!
On Fri, 9 Mar 2001, Tim Frank wrote: > I apologise if this has been posted/asked already, but since it has been > about a week and it hasn't been "fixed" I needed to ask. Every time I > issue a search at http://www.postgresql.org/search.mpl even on the > easiest of search items, such as "postgres" I get a result of this, and > only this: > > Search results: postgres : 33688 > > Displaying documents 0-0 of total 33688 found. (0.00 secs) > > Now it still seems to take its sweet time to search so it seems like the > search is working, just no results are actually getting displayed. > > Has anyone else noticed this? Does it just not like me? Okay, this is odd ... I just tried the search functions under the mailing lists themselves, and it returns proper results ... Well, that would explain that ... the ones under the mailing lists are using the old database, while the main one you are referencing is using the new database ... schema hasn't changed, but will investigate and see if I can figure it out :(
fixed ... not sure exactly *why* it broke, but just installed the newest perl interface at http://www.postgresql.org/search.mpl, did a searchon 'mvcc' and search came back in 5.9sec (result time is on the page and appears to be accurate now) ... the sub-page searches have to be updated to the new database next, but this one should work now ... please let me know if there are any further problems ... On Fri, 9 Mar 2001, Tim Frank wrote: > I apologise if this has been posted/asked already, but since it has been > about a week and it hasn't been "fixed" I needed to ask. Every time I > issue a search at http://www.postgresql.org/search.mpl even on the > easiest of search items, such as "postgres" I get a result of this, and > only this: > > Search results: postgres : 33688 > > Displaying documents 0-0 of total 33688 found. (0.00 secs) > > Now it still seems to take its sweet time to search so it seems like the > search is working, just no results are actually getting displayed. > > Has anyone else noticed this? Does it just not like me? > > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org