As Scott mentioned, kill -9 on a Postgres process is not a wise idea on a Postgres process.If you query is coming from another application, then terminating that application with a kill -9 *may* work, but is, as scott says, a last resortI tend to use kill -TERM (15) to disconnect the client, which
> > I have a table with 40 million rows and haven't had any performance > issues yet.> > Are there any rules of thumb as to when a table starts getting too big?> > For example, maybe if the index size is 6x the amount of ram, if the> table is 10% of total disk space, etc?> > > -- > My rule here is
> > >> > > I have a table with 40 million rows and haven't had any performance> > > issues yet.> > >> > > Are there any rules of thumb as to when a table starts getting too big?> > >> > > For example, maybe if the index size is 6x the amount of ram, if the> > > table is 10% of total disk space, etc