Marcin: This heppens everytime when i try to query different keyword in FTS
for example:
firsttime: query: "Hello & World" 15sec~
secondtime: query: "Hello & World" 2-3sec
then new query
firsttime: query: "We & are & good" 10sec~
secondtime: query: "We & are & good" 2-3sec
even if i'm going fro
On Mon, Jun 24, 2013 at 11:55 AM, Emrah Mehmedov
wrote:
> Marcin: This heppens everytime when i try to query different keyword in FTS
> for example:
>
> firsttime: query: "Hello & World" 15sec~
> secondtime: query: "Hello & World" 2-3sec
>
> then new query
>
> firsttime: query: "We & are & good" 1
hello postgresql experts --
i have a strange row estimate problem, which unfortunately i have trouble
reproducing for anything but very large tables which makes boiling down to a
simple example hard. i'm using version 9.1.1, all tables have had analyze run
on them.
here's the example : i have
On Mon, Jun 24, 2013 at 3:18 PM, Ben wrote:
>
> create table jointable (
> id1 integer not null,
> id2 date not null,
> id3 integer not null,
> id4 time not null,
> id5 integer not null
> );
>
> and then perform a join against this table.
>
Is it safe to assume you ANALYZEd the jointab
hello --
On Jun 24, 2013, at 4:23 PM, bricklen wrote:
> Is it safe to assume you ANALYZEd the jointable after creating it? (I assume
> so, just checking)
yes, jointable was analyzed. both tables were further analyzed after any
changes.
> Can you post the output of:
>
> SELECT version();
>
Hello,
If a table takes 100 MB while on disk, approximately how much space will it
take in RAM/database buffer?
Context - We are designing a database that will hold a couple of GBs of data.
We wanted to figure out how much shared_buffers we should provide to ensure
that most of the time, all th
