Andrew Sullivan wrote:
> This is probably better on -performance, and is certainly a FAQ.
> But. . .
>
> On Wed, Feb 23, 2005 at 03:01:52PM +0100, Thomas Braad Toft wrote:
> >
> > Table device contains 5285 rows, tmeevent contains 834912 rows.
>
This is probably better on -performance, and is certainly a FAQ.
But. . .
On Wed, Feb 23, 2005 at 03:01:52PM +0100, Thomas Braad Toft wrote:
>
> Table device contains 5285 rows, tmeevent contains 834912 rows.
^^
> -> Seq Scan on tmeevent
Hello,
I'm having two tables (listed):
CREATE TABLE "public"."device" (
"id" BIGSERIAL,
"name" TEXT,
"serialnumber" TEXT,
-- many more columns --
) WITH OIDS;
CREATE UNIQUE INDEX "device_id_key" ON "public"."device"
USING btree ("id");
CREATE INDEX "device_name_index" ON "public
