Re: [HACKERS] For cursors, there is FETCH and MOVE, why no TELL?
Hi, 2015-02-09 10:37 GMT+01:00 Marc Balmer m...@msys.ch: (I use cursors to display large datasets in a page-wise way, where the user can move per-page, or, when displaying a single record, per record. When the user goes back from per-record view to page-view, I have to restore the cursor to the position it was on before the user changed to per-record view.) On a totaly unrelated note: http://use-the-index-luke.com/de/blog/2013-07/pagination-done-the-postgresql-way kind regards hakm kocaman -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Parameterized-path cost comparisons need some work
2012/4/18 Greg Stark st...@mit.edu On Tue, Apr 17, 2012 at 5:14 PM, Tom Lane t...@sss.pgh.pa.us wrote: I've been hacking away on a patch to do this, and attached is something that I think is pretty close to committable. [..]Even when some of us don't comment on some of the longer, more technical emails, we're definitely still reading them and I at least find them invaluable for trying to keep up with the changes over time. [..] +1 hakan
[HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
Hi, for whom it may concern: http://pdos.csail.mit.edu/mosbench/ They tested with 8.3.9, i wonder what results 9.0 would give. Best regards and keep up the good work Hakan
Re: [HACKERS] Overhauling GUCS
On 6/9/08, Gregory Stark [EMAIL PROTECTED] wrote: Josh Berkus [EMAIL PROTECTED] writes: Where analyze does systematically fall down is with databases over 500GB in size, but that's not a function of d_s_t but rather of our tiny sample size. n_distinct. For that Josh is right, we *would* need a sample size proportional to the whole data set which would practically require us to scan the whole table (and have a technique for summarizing the results in a nearly constant sized data structure). Hi, is this (summarizing results in a constant sized data structure) something which could be achived by Bloom-Filters ? http://archives.postgresql.org/pgsql-general/2008-06/msg00076.php Kind regards Hakan Kocaman
Re: [HACKERS] I need your help!!
Hi, if you want to use a gui-tool try pgadmin3 http://www.postgresql.org/ftp/pgadmin3/release/v1.4.3/win32/ if you want to access your db from a generic client tool like access try the pgsqlodbc-driver official page http://pgfoundry.org/projects/psqlodbc/ latest snapshots http://www.geocities.jp/inocchichichi/psqlodbc/index.html HINT : This is the list for pgsql-development, better try the general-list pgsql-general@postgresql.org here you can choose the right list to subscribe : http://www.postgresql.org/community/lists/subscribe At available lists choose general or novice or read the faq Best regards Hakan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of mario tovilla Sent: Wednesday, August 30, 2006 12:41 AM To: pgsql-hackers@postgresql.org Subject: [HACKERS] I need your help!! Hi!! I hope you are not too busy. The thing is that i need to connect my pc which is on windows XP and the server is on linux with postgres. The question is? how do I connect my windows machine to the server with postgres? What do I have to do?, put it in steps please!!! thanks you guys are great!!! _ Prodigy/MSN Search. Todo lo que buscas ahora más rapido http://search.t1msn.com.mx/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster