Most of the installations I have seen reach out to the Internet during the
process. How hard is it to build a Postgres installation in a completely
isolated environment? I have an internal network with not Internet
connectivity that I would like to set up Postgres on.
Joey
In this case, I'm updating one column. Wouldn't the "swap" part of that
still have to be an update?
On Wed, Nov 27, 2013 at 9:50 AM, Merlin Moncure wrote:
> On Wed, Nov 27, 2013 at 8:35 AM, Joey Quinn wrote:
> > So, no cancel... keeping my fingers crossed (r
ider mutliple parallel
> psql.
>
> Cheers,
>
> Rémi-C
>
>
>
> 2013/11/27 Joey Quinn
>
>> Wow, thank-you (sometimes the answer is right there in front of you...
>> very new to Postgres, had wondered what the difference was between the run
>> query and r
into X parts), yet Joey seemed reluctant to
> use console =)
>
>
> Cheers,
> Rémi-C
>
>
> 2013/11/27 Albe Laurenz
>
>> John R Pierce wrote:
>> > On 11/26/2013 9:24 AM, Joey Quinn wrote:
>> >> When I ran that command (select * from pg_stat_activity
Wow, thank-you (sometimes the answer is right there in front of you... very
new to Postgres, had wondered what the difference was between the run query
and run as PGS script, but hadn't looked into it yet).
So, here's the critical question(s) right now (for me)...
With the way I launched it, usin
yeah, unlikely that it is already in the path (I certainly didn't add it
yet).
Thanks for the command (new version).
On Tue, Nov 26, 2013 at 3:13 PM, John R Pierce wrote:
> On 11/26/2013 11:45 AM, Joey Quinn wrote:
>
>> Would that command be from within the psql SQL Shell
nope, that appears to be being blocked by the updates...
tried "select * from ipv4_table where country='gb' limit 1;"
it just sat there...
On Tue, Nov 26, 2013 at 3:00 PM, Vick Khera wrote:
>
> On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn wrote:
>
>> The ra
count on the county field... hate to throw queries at it while it's
busy updating though...
On Tue, Nov 26, 2013 at 1:43 PM, Vick Khera wrote:
>
> On Tue, Nov 26, 2013 at 12:24 PM, Joey Quinn wrote:
>
>> When I ran that command (select * from pg_stat_activity"), it
ohn R Pierce wrote:
> On 11/26/2013 9:24 AM, Joey Quinn wrote:
>
>> When I ran that command (select * from pg_stat_activity"), it returned
>> the first six lines of the scripts. I'm fairly sure it has gotten a bit
>> beyond that (been running over 24 hours now,
The ipv4 column is of type inet. It is the primary key (btree access) and
access times for queries on individual ip addresses have been around 10-15
ms.
On Tue, Nov 26, 2013 at 12:13 PM, Vick Khera wrote:
>
> On Tue, Nov 26, 2013 at 12:11 PM, Joey Quinn wrote:
>
>> update
run fast before you
> started. :)
>
>
> On Tue, Nov 26, 2013 at 10:28 AM, Joey Quinn wrote:
>
>> I have a fairly large table (4.3 billion rows) that I am running an
>> update script on (a bit over 127 thousand individual update queries). I am
>> using the gui. It ha
low to not use a single transaction ( but instead
> 127k transactions).4
>
> Then at the end of every transaction you could print something in gui
> (print for pgscript, raise for plpgsql) or execute a command to write in a
> file (copy for instance).
> It would also be in the log, but
I have a fairly large table (4.3 billion rows) that I am running an update
script on (a bit over 127 thousand individual update queries). I am using
the gui. It has been running for about 24 hours now. Is there any good way
to gauge progress (as in, how many of the individual update queries have
fi
>From the way the table was filled, I knew there were no nulls. It succeeded.
On Thu, Nov 21, 2013 at 8:15 PM, Joshua D. Drake wrote:
>
> On 11/21/2013 12:40 PM, Joey Quinn wrote:
>
>> I have a table (5 columns) with approximately 670 million rows. It has
>> had an i
yep, that worked... thanks again.
On Thu, Nov 21, 2013 at 4:38 PM, Joey Quinn wrote:
> Ahhh, that's what I was missing... thank-you. (just launched, we'll see
> how that one goes).
>
>
>
> On Thu, Nov 21, 2013 at 3:48 PM, Elliot wrote:
>
>> On 2013-11-21 1
Ahhh, that's what I was missing... thank-you. (just launched, we'll see how
that one goes).
On Thu, Nov 21, 2013 at 3:48 PM, Elliot wrote:
> On 2013-11-21 15:40, Joey Quinn wrote:
>
>> I have a table (5 columns) with approximately 670 million rows. It has
>> had
I have a table (5 columns) with approximately 670 million rows. It has had
an index (unique) on an inet column from the beginning. Today I added a
primary key constraint based on the same column thinking that since it
already had an index, this would be a relatively quick operation. That does
not a
Thank-you all... create extension hstore; was exactly what I needed (I'm
new to PostgreSQL and was unfamiliar with the terminology... was searching
unsuccessfully for things like "install hstore module").
Joey
On Wed, Nov 20, 2013 at 4:12 PM, Joey Quinn wrote:
> I'm us
I'm using 9.3 (Windows 64 bit) and would like to use an hstore field in new
table but it does not appear to be available. How do I add the correct
module?
Joey
19 matches
Mail list logo
