On Apr 7, 11:14 am, [EMAIL PROTECTED] (Alan Hodgson) wrote:
On Monday 07 April 2008, Dan99 [EMAIL PROTECTED] wrote:
Does TRUNCATE TABLE keep all necessary table
information such as indexes, constraints, triggers, rules, and
privileges?
Yes. It does require an exclusive lock on the table
On Apr 5, 6:36 pm, [EMAIL PROTECTED] (Douglas McNaught) wrote:
On Thu, Apr 3, 2008 at 2:34 PM, Dan99 [EMAIL PROTECTED] wrote:
Hi,
I am having some troubles with a select group of tables in a database
which are acting unacceptably slow. For example a table with
approximately 10,000
On Mon, Apr 7, 2008 at 9:51 AM, Dan99 [EMAIL PROTECTED] wrote:
Unfortunately, I did not design this database (or the website for that
matter) and am only maintaining it. As a result of the inexperience
of the website designer, there are no indexes in any of the tables and
it would be
On Monday 07 April 2008, Dan99 [EMAIL PROTECTED] wrote:
Does TRUNCATE TABLE keep all necessary table
information such as indexes, constraints, triggers, rules, and
privileges?
Yes. It does require an exclusive lock on the table very briefly, though,
which DELETE does not.
Currently a mass
Douglas McNaught wrote:
You need to ANALYZE the tables after you load them, and make sure you
have indexes on the column you're querying (which it sounds like you
do, but they're not being used because the statistics for the table
are inaccurate).
I've seen discussion here that made it sound
Craig Ringer [EMAIL PROTECTED] writes:
Douglas McNaught wrote:
You need to ANALYZE the tables after you load them, and make sure you
have indexes on the column you're querying (which it sounds like you
do, but they're not being used because the statistics for the table
are inaccurate).
Hi,
I am having some troubles with a select group of tables in a database
which are acting unacceptably slow. For example a table with
approximately 10,000 rows took about 3,500ms to extract a single row
using the following select statement:
SELECT * FROM table WHERE column = 'value'
I have
On Thu, Apr 3, 2008 at 2:34 PM, Dan99 [EMAIL PROTECTED] wrote:
Hi,
I am having some troubles with a select group of tables in a database
which are acting unacceptably slow. For example a table with
approximately 10,000 rows took about 3,500ms to extract a single row
using the following