Re: Simple join doesn't use index
От
Filip Rembiałkowski
Тема
Re: Simple join doesn't use index
Дата
Msg-id
CAP_rwwk2JVR6gFZs_j7ASPMctB3xbUeEfVCyiVbrJiKOjZ+eLg@mail.gmail.com
Ответ на
Re: Simple join doesn't use index (Alex Vinnik)
Список
Дерево обсуждения
Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Jeremy Harris <jgh@wizmail.org>
Re: Simple join doesn't use index Stefan Andreatta <s.andreatta@synedra.com>
Partition table in 9.0.x? AJ Weber <aweber@comcast.net>
Re: Partition table in 9.0.x? Jeff Janes <jeff.janes@gmail.com>
Re: Partition table in 9.0.x? AJ Weber <aweber@comcast.net>
Re: Partition table in 9.0.x? Jeff Janes <jeff.janes@gmail.com>
Re: Partition table in 9.0.x? AJ Weber <aweber@comcast.net>
Re: Partition table in 9.0.x? Jeff Janes <jeff.janes@gmail.com>
Re: Partition table in 9.0.x? Tom Lane <tgl@sss.pgh.pa.us>
Re: Partition table in 9.0.x? AJ Weber <aweber@comcast.net>
Re: Partition table in 9.0.x? Jeff Janes <jeff.janes@gmail.com>
Re: Simple join doesn't use index Merlin Moncure <mmoncure@gmail.com>
Re: Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Merlin Moncure <mmoncure@gmail.com>
Re: Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Merlin Moncure <mmoncure@gmail.com>
Re: Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Merlin Moncure <mmoncure@gmail.com>
Re: Simple join doesn't use index Jeff Janes <jeff.janes@gmail.com>
Re: Simple join doesn't use index Jeff Janes <jeff.janes@gmail.com>
Re: Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Filip Rembiałkowski <plk.zuber@gmail.com>
Re: Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Ben Chobot <bench@silentmedia.com>
Re: Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Merlin Moncure <mmoncure@gmail.com>
Re: Simple join doesn't use index Alex Vinnik <alvinnik.g@gmail.com>
Re: Simple join doesn't use index Filip Rembiałkowski <plk.zuber@gmail.com>
Re: Simple join doesn't use index Dan Fairs <dan.fairs@gmail.com>
Re: Simple join doesn't use index Jeff Janes <jeff.janes@gmail.com>
Re: Simple join doesn't use index Jeff Janes <jeff.janes@gmail.com>
On Mon, Jan 28, 2013 at 5:43 PM, Alex Vinnik <alvinnik.g@gmail.com> wrote:
do you know pgtune?
it's a good tool for starters, if you want a fast postgres and don't really want to learn what's behind the scenes.
random_page_cost=1 might be not what you really want.
it would mean that random reads are as fast as as sequential reads, which probably is true only for SSD
Filip
It sure turned out that default settings are not a good fit.
do you know pgtune?
it's a good tool for starters, if you want a fast postgres and don't really want to learn what's behind the scenes.
random_page_cost=1 might be not what you really want.
it would mean that random reads are as fast as as sequential reads, which probably is true only for SSD
Filip
В списке pgsql-performance по дате отправления
