Closed
Bug 841905
Opened 13 years ago
Closed 13 years ago
ANALYZE runs for master02 db post failover/restart
Categories
(Socorro :: Database, task)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: selenamarie, Assigned: selenamarie)
Details
Attachments
(4 files)
Tables need ANALYZE data in order to get good planner estimates.
These values get reset when the database is brought up from a replica. I'm scheduling some ANALYZEing for the weekend to make queries happier.
|
Assignee | |
Comment 1•13 years ago
|
||
|
|
Assignee | |
Comment 2•13 years ago
|
||
|
|
Assignee | |
Comment 3•13 years ago
|
||
|
|
Assignee | |
Comment 4•13 years ago
|
||
|
|
Assignee | |
Comment 5•13 years ago
|
||
Installed cron to run analyze on partitioned tables tomorrow:
[postgres@tp-socorro01-master02 ~]$ crontab -l
0 0 * * 6 /var/lib/pgsql/bin/analyze_partitioned.sh /var/lib/pgsql/bin/partitioned-tables-test 1 > /var/lib/pgsql/analyze.log 2>&1
Status: NEW → ASSIGNED
|
|
Assignee | |
Comment 6•13 years ago
|
||
Went well! Only took about 15 minutes.
Assignee: nobody → sdeckelmann
|
|
Assignee | |
Updated•13 years ago
|
Status: ASSIGNED → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•