Sorry for the paleo post but curious if there was ever a resolution for
this issue regarding BDR member join/eject:
https://goo.gl/N7FoUB
I'm currently seeing very similar behavior for the latest version of BDR
where cluster nodes are very confused about the state of their
connections/replication
Thank you for mentioning location, Josh.
I should have noted that I am in the western United States.
From: Joshua D. Drake
Sent: Monday, February 27, 2017 4:39:08 PM
To: Nathan Stocks; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Conferences for a DBA
What worthwhile conferences should a PostgreSQL DBA consider going to?
There have been some good sessions at OSCON in the past, but I was wondering
about more DBA-specific events.
~ Nathan
On 1/15/2015 12:36 PM, Daniel Begin wrote:
Thank, there is a lot of potential ways to resolve this problem!
For Rob, here is a bit of context concerning my IT environment…
Windows 7 64b Desktop, running with an Intel i7 core and 16GB ram. The
PostgreSQL 9.3 database is stored on a 3TB extern
On Thu, May 23, 2013 at 2:51 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On 05/23/2013 02:36 PM, Oscar Calderon wrote:
>
>> Hi, this question isn't technical, but is very important for me to know.
>> Currently, here in El Salvador our company brings PostgreSQL support, but
>> Ora
de to dateroll the
system. Until then the time field continues to grow, so you see times
like 25:00 and 26:00 all the time.
Exceptions abound.
--
Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jan 8, 2013 6:15 PM, "Kirk Wythers" wrote:
>
>
> On Jan 8, 2013, at 6:48 PM, Tom Lane wrote:
>
>> The OP didn't
>> suggest how many years his data covers, but it's quite possible that
>> pulling a full year's worth of data will read enough of the table that
>> there's no point in worrying abou
On Dec 11, 2012 2:25 PM, "Adrian Klaver" wrote:
>
> On 12/11/2012 01:58 PM, Mihai Popa wrote:
>>
>> On Tue, 2012-12-11 at 10:00 -0800, Jeff Janes wrote:
>>>
>>> On Mon, Dec 10, 2012 at 12:26 PM, Mihai Popa wrote:
Hi,
I've recently inherited a project that involves importing a
On Sun, Sep 30, 2012 at 06:54:35PM +0200, Levente Kovacs wrote:
> I've been using PostgreSQL for quite while, but I'd need some direction on
> how to handle an opened socket to the database in longer periods.
>
> I open the connection to my database with PQconnectdb().
>
> I access the database,
On Tue, 15 Nov 2011 18:56:37 -0700, J.V. wrote:
I have a table with existing data for which I need to:
1) drop the single primary key column (int4)
2) recreate the column with the pk (not null) constraint deferred
3) repopulate the column from a sequence
4) enable the constraint
When I issue th
Does anyone have a concise way of doing $SUBJECT?
Best,
Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
8) / (33 - 8) / 10 * 1302 = 10.416
> instead of 11 and 7?
> Perhaps I am missing something. I'd appreciate if you can point it out.
IIRC, you need to subtract the rows that are mcv's from the row count.
ie, you're not working with the full 1302 rows, only the ones that are
not m
st. so what's the recommended
way to use spi_exec_prepared() while being able to free the ram that
it allocates for its result set? sometimes i just want everything and
don't want to bother with a cursor.
thanks,
nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
>
> There is reference to slides with some
> frequency though, are they available somewhere?
>
Ya.
http://encodestatistics.org/publications/statistics_and_postgres.pdf
Is there a better place for this?
-Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
I have this XML that I don't wish to parse out to tables (BTDT and
don't wish to go there for the most part). There might be the
uncommon chance where an XML-friendly operation would be very useful.
On 9/16/09, Scott Bailey wrote:
>> I'm looking for the current state of XML capabilities in Post
Hello,
I'm looking for the current state of XML capabilities in PostgreSQL and I'm
coming up with a lot of confusing links and a bit short on documentation.
I first read that there used to be an xml2 contrib module for Postgres that
provided a lot of functions to read/write and simultaneously val
iel
verite)
explicitly decode bytea after select via sth: no
nathan
On Sun, Aug 23, 2009 at 9:20 AM, Colin
Streicher wrote:
> I'm probably a little late to this discussion, but I have had issues before
> with BYTEA in postgres before as well, this is what I found worked.
>
> use Di
cute($id);
my $newref = $getall_sth->fetchrow_hashref;
my $newdata = $newref->{data};
print md5_hex($data).' ';
print '!' if md5_hex($data) ne md5_hex($newdata);
print '= '.md5_hex($newdata);
print "\n";
--
nathan
On Sat, Aug 22, 2009 at 9:17 AM, Dan
good catch - it's because i'm used to working in plperlu.
unfortunately commenting out those lines makes no difference for this
particular data (that i linked in my original email); it's still
corrupted:
# ./bytea.pl
37652cf91fb8d5e41d3a90ea3a22ea61 != ce3fc63b88993af73fb360c70b
1)) : "\\"!ge; #decode
bytea column storage format
print md5_hex($data).' ';
print '!' if md5_hex($data) ne md5_hex($newdata);
print '= '.md5_hex($newdata);
print "\n";
__END__
hash of data changes ... if you uncomment the $data = '123abc&#x
le" to
have all privileges on all tables in the database "sample".
Any insight would be much appreciated.
Thanks,
Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
http://archives.postgresql.org/pgsql-general/2006-08/msg01472.php
... which suggests to me that it is indeed possible, but I would like
more details.
Thank you very much.
Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
variants table, all phenotypes are in
the phenotypes table, and you join through association. It's not as
elegant as inheritance, but it will be much more flexible in both the
types of queries that you can write and in case your requirements
change.
-Nathan
--
Sent via pgsql-general mailing
>> Will there be a saved version of this (SFPUG talk) available for later
>> viewing? Don't
>> make me choose between steak and beer and postgres. 8(
>
> Yes! I'll announce it here when it's available.
>
Is there any update on this?
-Nathan
--
Brilliant!
On Fri, Aug 1, 2008 at 12:18 PM, Steve Crawford
<[EMAIL PROTECTED]> wrote:
> Nathan Thatcher wrote:
>>
>> I have, what I imagine to be, a fairly simple question. I have a query
>> that produces output for a line graph. Each row represents an interval
>>
I have, what I imagine to be, a fairly simple question. I have a query
that produces output for a line graph. Each row represents an interval
on the graph.
SELECT COUNT(call_id) AS value, EXTRACT(hour from start_time) AS hour
FROM c_call WHERE start_time >= '2008-08-01 00:00:00' AND end_time <=
'
> I have a query that takes 2 sec if I run it from a freshly restored dump.
> If I run a full vacuum on the database it then takes 30 seconds.
What do the two plans look like? Can you post the explains?
-Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
I am trying to automatically create a database right after installing
postgres. I launch the silent install (Windows) from my own executable
and once it is done I need to create a database, tables, etc. I am
trying to find a way to do this without having to explicitly enter the
password in at the c
Tue, May 13, 2008 at 5:43 PM, Nathan Thatcher <[EMAIL PROTECTED]> wrote:
>
> > Is this the correct way to do this, or is there a better way / a way
> > to get PostgreSQL to recognize an alias in the HAVING clause?
>
> As Tom pointed out, f1's not in scope for the H
Oops, that second query should be
SELECT COUNT(*), id % 3 AS f1 FROM table GROUP BY f1 HAVING id % 3 <> 0;
On Tue, May 13, 2008 at 3:43 PM, Nathan Thatcher <[EMAIL PROTECTED]> wrote:
> I am in the middle of switching a bunch of queries over from MySQL to
> PostgreSQL and have
I am in the middle of switching a bunch of queries over from MySQL to
PostgreSQL and have hit a little snag. The following query works fine
in MySQL but raises an error in postgres:
SELECT COUNT(*), id % 3 AS f1 FROM table GROUP BY f1 HAVING f1 <> 0;
It seems that Postgres does not recognize the
So what options does that leave all of us who need to compile and run
our custom C functions in Windows?
On Sun, May 4, 2008 at 4:47 PM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> Magnus Hagander wrote:
>
>
> > Dan "Heron" Myers wrote:
> >
>
>
> >
> > > I read somewhere on Postgres' website that th
First off, I am developing custom c functions for PostgreSQL 8.3 in
Windows (sorry... not my choice). It appears that there is some
underlying problem in the server that is causing a runtime error to
crash the server when I use palloc. For example... I run the
following:
PG_FUNCTION_INFO_V1(add_on
I have been creating some user defined C functions using minGW and
postgreSQL 8.3. Everything works great when I use integers,
timestamps, points, etc. I have compiled, linked, created, and tested
multiple function and aggregates.
The problem occurs when I have a text parameter and need to use
PG_
inactive_users allows me to
tell the database (indirectly) that the active users index should stay
in memory, while the inactive users can relegated to disk.
-Nathan
On Thu, May 1, 2008 at 6:02 AM, Jeremy Harris <[EMAIL PROTECTED]> wrote:
> Gurjeet Singh wrote:
>
> > One of the
Hello - Curious if anyone has any experience with the new UUID type in
8.3? We are currently using sequences for all of our keys and ids.
However using a UUID instead of a sequence would make some parts of the
application easier. However we have a few concerns about performance
issues surroundi
Jan Wieck wrote:
On 2/12/2008 3:04 PM, Tom Lane wrote:
Nathan Wilhelmi <[EMAIL PROTECTED]> writes:
Hello - Trying to track down a lock contention problem, I have a
process that does a series of select / insert operations. At some
point the process grabs a series of RowExclusiveLock(
Tom Lane wrote:
Nathan Wilhelmi <[EMAIL PROTECTED]> writes:
Hello - Trying to track down a lock contention problem, I have a process
that does a series of select / insert operations. At some point the
process grabs a series of RowExclusiveLock(s) and has the obvious effect
of st
Hello - Trying to track down a lock contention problem, I have a process
that does a series of select / insert operations. At some point the
process grabs a series of RowExclusiveLock(s) and has the obvious effect
of stalling other processes. I logged all the statements and don't see
any for up
ong, though easily modified to add "and table1_id = foo".
> Wouldn't I need to use a UNION for this kind of query?
A union will combine rows (if they're compatible) from two queries,
What you are asking is to assemble columns, which is entirely different.
--
nathan wagner
hat
"a BETWEEN x AND y
is equivalent to
a >= x AND a <= y"
Which is wrong (though it may be required by the standard, of course).
1 is not between 1 and 2. "between" shouldn't include the endpoints.
At any rate, the OP will know what he meant by "betwe
Hello - Typically case of a software guy needing to spec hardware for a
new DB server. Further typified case of not knowing exact amount of data
and I/O patterns. So if you were to spec a disk system for a new general
purpose PostgreSQL server any suggestions of what to start with?
Details I h
Hello - We are using PG_ADMIN backup to create the schema DDL scripts
for our application. Is there any way to get PGAdmin to not include the
encoding value or configure PostgreSQL to set the client encoding to
UNICODE? Having problems with the JDBC driver and the UTF8 encoding when
we try to e
(1 row)
granicus%
but I probably wouldn't do it this way at all. something like
(untested)
select A.name, A.val1 as age, S.val12 as size
from agedata A left outer join sizedata S on S.name = A.name;
should work.
--
Nathan Wagner
[EMAIL PROTECTED]
---
Hello - Does anyone happen to have a SQL script or function that can
reset all the sequence values found in a given DB? When we rebuild the
DB it would be handy to be able to set all the sequence back to a known
starting place.
Thanks!
-Nate
---(end of broadcast)
Hello - Trying to find out how much floating point operation performance
effects Postgres in general. Looking at some lower power machines that
have good integer performance but not great floating point performance,
shared FPU across cpus. If we store, but don't use in query criteria,
floating
Hello - Several people kindly responded directly to me with some
specific suggestions for this, however the message was mistakenly
deleted and not in the archives. If you remember who you are and
wouldn't mind resending that would be fantastic!
Thanks!
-Nate
Hello - Just installed 8.2.4 on a
Hello - Just installed 8.2.4 on a Solaris 9 box. It's an 8-way (15000
MHz sparc) with 32GB of ram. We don't know the exact table structure yet
or access patterns, although the first thing that will be looked at is a
Sesame triple store DB. I would expect that this DB will be more skewed
to read
the sub-select to a different non-volatile view or do
I need to create a non-volatile function that returns the result?
Thanks for the help.
Tom Lane wrote:
Nathan Bell <[EMAIL PROTECTED]> writes:
Firing up 8.2.1 I notice that sub-items in a view are optimized out if
they
for
illistration purposes only, and is made only to take time.
Thanks in advance for any help,
Nathan Bell
IT Engineer
Action Target, Inc.
create trusted language 'plpgsql'
handler plpgsql_call_handler lancompiler 'PL/pgSQL';
create table small ( only_item int4 );
cre
rmal processor usage sits at about
10%. Maybe it keeps trying to cache and resort table2? I don't really
have any idea, but that is my only guess.
If anyone knows why this may be happenning, I would really appreciate it.
Thanks,
Nathan
Hello - Ran into an interesting problem last week with data unexpectedly
being deleted. Has anyone else experienced this and have any suggestions
on how to prevent this in the future?
Here is the environment:
Server: 8.0.3 on Solaris 9
JDBC Driver: 8.0.311
This is the series of statements tha
?Have I addressed my question to the correct list?Nathan Nathan Leon Pace, MD, MStatUniversity of UtahSalt Lake City, UT 84132Office: 801.581.6393Fax: 801.581.4367Cell: 801.205.1019Pager: 801.291.9019Home: 801.467.2925
Is there a way to check to see if a record has a foreign key, before I try to delete a record ?
To check first to see if this record is tied to a foreign key before I try to change it, thus avoiding
a foreign key error.
on? Should I create a different user?
NM
--
Nathan Mealey
Director of Operations
Cycle-Smart, Inc.
P.O. Box 1482
Northampton, MA
01061-1482
[EMAIL PROTECTED]
(413) 587-3133
(413) 210-7984 Mobile
(512) 681-7043 Fax
I want the following trigger to update a related table when ever a
record is inserted/updated. I have the following trigger:
CREATE TRIGGER update_status
AFTER INSERT OR UPDATE
ON public."Bug Status"
FOR EACH ROW
EXECUTE PROCEDURE public.update_status();
Which Calls this function:
CREATE OR
r advice are greatly
appreciated.
Nathan Heagy
^^
Front Logic . Vividworks . Cow Comics . Thirty-Nine Days
r advice are greatly
appreciated.
Nathan Heagy
^^
Front Logic . Vividworks . Cow Comics . Thirty-Nine Days
I am trying to create an index on the date_trunc('day', columna) in a table.
When I try to create this index, I get a parse error near the single quote.
Is there a workaround to create this index? I am using v7.0.3 on FreeBSD.
-Nathan Barnett
on the list can probably
correct me if any of this is incorrect.
-----
Nathan Barnett
-Original Message-
From: Nikhil G. Daddikar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 3:21 AM
To: Nathan Barnett; [EMAIL PROTECTED]
Subjec
ity of
Postgres in a production environment.
-----
Nathan Barnett
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Nikhil G.
Daddikar
Sent: Tuesday, December 12, 2000 8:42 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] R
o complete this query without using all the RAM?
-----
Nathan Barnett
Stephan,
Thanks for the initial help. I followed your instructions, but now I'm
getting an error: "ERROR: RelationBuildTriggers: 2 record(s) not found for
rel nametable". Where else would these triggers be referenced.
-----
by the number of 'set digest' messages I am seeing on the list I can finally assume
that I am not the only one that this has happened to. The general list seems to have
lost its digest setting, and for some reason I also got subscribed to the Hacker list.
While I like receiving these messages
time.
---
Nathan Barnett
nction |arguments |description
+-+---+---
text|text_substr |text int4 int4 |return portion of string
Is this in 7.0 ?
(PS this is not user defined, well at least I did not make it ...? )
thank you
nathan
I have installed the beta 7 for postgres but... it seems to be missing
some text functions ? l
like the textsubstr ?
Is this beacuse it is a "beta" and the final release will include these
or are they forever droped ?
Please let me know
thank you
nathan
ND DECLARE SECTION;
EXEC SQL CONNECT 'nathan';
EXEC SQL DECLARE lets_get_tid CURSOR FOR
SELECT type.tid;
printf("Choose the TID to delete\n\n \n");
do{
EXEC SQL OPEN lets_get_tid;
EXEC SQL FETCH lets_get_tid INTO //line 255
:Atid;
printf("%s
de to 6.2.1 it compiles just fine.
Does anyone know the solution to (or a workaround for) this problem?
Thanks very much in advance.
Nathan L. Cutler
69 matches
Mail list logo
