Re: [HACKERS] For cursors, there is FETCH and MOVE, why no TELL?

2015-02-09 Thread Hakan Kocaman
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-04-18 Thread Hakan Kocaman
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

2010-10-04 Thread Hakan Kocaman
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

2008-06-09 Thread Hakan Kocaman
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!!

2006-08-30 Thread Hakan Kocaman
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