"Emiliano Leporati" <[EMAIL PROTECTED]> writes:
> can anybody explain me why this happens ? and if i should try different
> indexes ?
Showing EXPLAIN ANALYE output would probably make things a lot clearer.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgs
On Tue, Jul 1, 2008 at 4:49 AM, Emiliano Leporati
<[EMAIL PROTECTED]> wrote:
> Hi,
> i have a table with a huge amount of rows (actually 4 millions and a half),
> defined like this:
>
> CREATE TABLE rtp_frame (
> i_len integer NOT NULL,
> i_file_offset bigint NOT NULL,
> i_file_id integ
Hi,
i have a table with a huge amount of rows (actually 4 millions and a half),
defined like this:
CREATE TABLE rtp_frame (
i_len integer NOT NULL,
i_file_offset bigint NOT NULL,
i_file_id integer NOT NULL, -- foreign key
i_timestamp bigint NOT NULL,
i_loop integer NOT NULL,
