by: Matt Liverance |
last post by:
I REALLY dont want to switch to oracle :( but I cant get these tables
working any faster.
I've got 2 dedicated servers, each with a slave, all run 32gig 15k rpm
raid 5 on u320 perc raid...
|
by: robberjohn |
last post by:
Hello all, I have a SQL 2000 Standard SP3 install. I was running low on
free space so added a secondary data file on a separate hard drive. I
did this for each of two databases.
Since then, and...
|
by: G.W. Lucas |
last post by:
I apologize if this is a RTFM question, but I have not been able
to find a definitive answer elsewhere.
Does a "REINDEX TABLE" lock the table while it is working?
Can applications write data to...
|
by: Sally Sally |
last post by:
I just started a REINDEX on a non-system table because I was getting "failed
to re-find parent key" while analyzing. I realized a little too late that
the docs said the pg server should have been...
|
by: Clodoaldo Pinto Neto |
last post by:
I suspect there is something wrong because it takes 73s to delete a single line
from a table whith 140 lines. So I tried to reindex the database:
bash-2.05b$ postgres -P -O -D /var/lib/pgsql/data...
|
by: Edmund Dengler |
last post by:
Howdy all!
Quick question regarding REINDEX. I have a large table with 1077455 rows.
I have an index on the table with a WHERE clause that limits the rows to
around 10-50. When I REINDEX this...
|
by: Ulrich Wisser |
last post by:
Hello,
the maintainance chapter in the docs gave me the impression that a
reindex of some tables would be a good idea. Last night I took the
database down, started up in single user mode and...
|
by: Raziq Shekha |
last post by:
Hi Folks,
SQL Server 2000 SP3 on Windows 2000. I have a database on which I ran
the command :
dbcc dbreindex ('tablename')
go
for all tables in the database. Then I compared the dbcc...
|
by: paul |
last post by:
Hi,
i have several tables in production whose contents are renewd totally in 1
week. So everyd day we delete ~15% records and then insert 15% new.
And after a few days, the performances drops :
...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|