Unix Technical Forum

Re: Limit changes query plan

This is a discussion on Re: Limit changes query plan within the pgsql Hackers forums, part of the PostgreSQL category; --> On Fri, Feb 01, 2008 at 12:08:56PM +0100, Gaetano Mendola wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-15-2008, 10:42 PM
Martijn van Oosterhout
 
Posts: n/a
Default Re: Limit changes query plan

On Fri, Feb 01, 2008 at 12:08:56PM +0100, Gaetano Mendola wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
> I'm using 8.2.6 and I'm observing a trange behaviour using
> offset and limits.


Please post EXPLAIN ANALYZE output so we can see what's actually taking
the time.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFHov95IB7bNG8LQkwRAjuzAJ9JN1aQB3IVWZnsGmNeB9 Z/vhNl+gCeKlop
92G9OQ8fCDcJAbhHnNtPORA=
=Dt8r
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:18 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com