Yves Vindevogel <[EMAIL PROTECTED]> writes:
> ns30966:~# ERROR: could not read block 3231 of relation
> 1663/165707259/173511769: Input/output error
> I get this error. Is this hardware related or could it be something
> with the postgresql.conf settings.
It's a hardware failure --- bad disk
ns30966:~# NOTICE: Executing SQL: update tblPrintjobs set ApplicationType = 1 where ApplicationType is null and upper(DocumentName) like '%.DOC'
ns30966:~# NOTICE: Executing SQL: update tblPrintjobs set ApplicationType = 1 where ApplicationType is null and upper(DocumentName) like 'DOCUMENT%'
On 11/11/05, DW <[EMAIL PROTECTED]> wrote:
I'm perplexed. I'm trying to find out why some queries are taking a longtime, and have found that after running analyze, one particular querybecomes slow.
i have had exactly the same problem very recently.
what helped? increasing statistics on come column