95 rows=1 loops=1)
Index Cond: ((timeslot <= '2016-10-20
21:40:00+00'::timestamp with time zone) AND (pollgrpid = 497582) AND (dsnum
= 0))
Total runtime: 2604.818 ms
(35 rows)
My problem is that if I run this against a newly created pollgrpid/dsnum
pair, there is no data in the earlier tables and my guess is that the query
switches to an seqence scan because I cannot get the query to finish ( my
last attempt did not complete after waiting 10 minutes ).
Any suggestions would be appreciated
George Woodring
iGLASS Networks
www.iglass.net
S Networks
www.iglass.net
On Thu, Dec 31, 2015 at 2:29 PM, George Woodring wrote:
> OS: CentOS 6.6
> Postgres Version: 9.3.10
>
> I have a script that is worked for years that does the following
>
> - Connect to postgres and get a list of URLs to poll for status
> - close connectio
I went and look and we have the ssl_renegotiation_limit set to the default,
which the documentation says is 0.
Thanks,
George
iGLASS Networks
www.iglass.net
On Thu, Dec 31, 2015 at 3:16 PM, Adrian Klaver
wrote:
> On 12/31/2015 11:29 AM, George Woodring wrote:
>
>> OS: CentOS 6.6
OS: CentOS 6.6
Postgres Version: 9.3.10
I have a script that is worked for years that does the following
- Connect to postgres and get a list of URLs to poll for status
- close connection
- Start threads to poll the URLs
- cleanup threads and collect the results.
- Connect to postgres and write t
r the viewer, without the web code having to know
the timezone.
George Woodring
iGLASS Networks
www.iglass.net
-- In your original post you mentioned that access to the databases is
through a Web server.
-- Is there just one Web server with one time zone?
We have 2 web servers that are clustered together. They are both set to
Eastern since that is the timezone they are located in.
iGLASS Networks
www.
27;US/Pacific" and I see it
change, when I do another RESET timezone it goes back to US/Eastern.
Thanks,
George Woodring
iGLASS Networks
www.iglass.net
On Mon, Feb 23, 2015 at 10:49 AM, Tom Lane wrote:
> George Woodring writes:
> > Yes, that is where we think we are heading, th
timezone y.
George Woodring
iGLASS Networks
www.iglass.net
On Mon, Feb 23, 2015 at 9:16 AM, Dave Cramer wrote:
> Well you could always just put it back to whatever you want when you open
> the connection ie "set timezone "
>
>
>
> Dave Cramer
>
> dav
3am PST when I pull it
out. If I save it to timestamp without timezone, I get 6am now where as
before I would get 3am.
Any suggestions would be appreciated
George Woodring
iGLASS Networks
www.iglass.net
easily.
Thanks again for the help, I will update if we find something useful
George
iGLASS Networks
www.iglass.net
On Mon, Feb 3, 2014 at 3:35 PM, Jeff Janes wrote:
> On Mon, Feb 3, 2014 at 11:16 AM, George Woodring <
> george.woodr...@iglass.net> wrote:
>
>> I am runnin
I am running 9.3.2 on CentOS 6.5
We have a new server we are migrating to that seems to lock up for up to
30sec at a time with all of the processes in wait. I am seeing a weird
output with the checkpoint logs and am wondering if I need to adjust
something with the checkpointer config.
My checkpo
Currently the documentation looks like:
client_min_messages (enum)
Controls which message levels are sent to the client. Valid values are
DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, ERROR, FATAL,
and PANIC. Each level includes all the levels that follow it. The later the
level,
We are still seeing the spike in vacuums every 8 days, even after upgrading
to 9.0.3. Any suggestions on how to spread them out?
Thanks,
George Woodring
>
> On Wed, Mar 16, 2011 at 7:12 PM, Aleksey Tsalolikhin <
> atsaloli.t...@gmail.com> wrote:
>
> Do you see thi
I was able to upgrade the machine on Wednesday to 9.0.3 and we saw the spike
on Thursday, right on the 8 day schedule. I will keep my eye out next
Friday to see if it happens again. This will have the whole period on the
new version.
Thanks
George
On Wed, Mar 16, 2011 at 7:12 PM, Aleksey Tsalol
autovacuum_freeze_max_age = 2
autovacuum_vacuum_cost_delay = 20ms
autovacuum_vacuum_cost_limit = -1
Any suggestions would be appreciated.
Thanks,
George Woodring
--
iGLASS Networks
www.iglass.net
<>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
I am running 8.3.3 currently on this box.
Last week we had a database corruption issue that started as:
Aug 24 07:15:19 iprobe028 postgres[20034]: [3-1] ERROR: could not read
block 0 of relation 1663/16554/7463400: read only 0 of 8192 bytes
Aug 24 07:15:49 iprobe028 postgres[27663]: [3-1] ERROR:
hanks for the suggestion.
Woody
On Mon, Apr 19, 2010 at 1:32 PM, Tom Lane wrote:
> George Woodring writes:
>> Upon investigation I found that I have a table that is in the database twice
>
>> db=> select oid, relname from pg_class where oid IN (26770910,
>>
I have found that I have a database problem after receiving the
following error from pg_dump:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: more than one row returned
by a subquery used as an expression
pg_dump: The command was: SELECT tableoid, oid, typname, typnamespace
We had the same problem after re-compiling on 8.1.2. We had to edit the
/etc/ld.so.conf file and add "/usr/local/pgsql/lib" manually.
There is a mention to this in the DBD::Pg readme file.
Woody
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3
I am looking for suggestions on storing and retrieving geocode
information.
My application currently stores 2 columns (lat, long) as numeric and I
have a btree index on them. This works fine for the current set of
data, but as it expands I know it will become an issue.
I am looking at changing t
I have install 8.1.2 on my test box and loaded data from a 7.4.8
database.
I was running fixseq.sql copied from the release notes to up date the
sequences and the output has an extra "\" character
ALTER TABLE public.modems_old ALTER COLUMN modemsid SET DEFAULT
nextval\('modems_id');
To fix it
I have a database that has been upgrade numerous times (Started about
7.1 and is not 7.4.8). The table has 2 foreign keys on it, but when I
look at the table I see that the FK applied before 7.4.X is written as a
trigger. Everything seems to work, I was just wondering if there are
any performance
I am trying to create a trigger that needs to capture the primary key
value out of NEW variable.
However the trigger can be called from 2 different tables whose PKs are
Table1id
Table2id
Is possible to declare a variable to build the column name
Tableid varchar(20) := TG_RELNAME || ''id'';
And
I have 2 existing tables in my db:
iss=> \d pollgrpinfo
Table "public.pollgrpinfo"
Column | Type | Modifiers
---++---
pollgrpinfoid | integer| not null
pollgrpid | integer| not
24 matches
Mail list logo
