e data
> consistency.
--
Scott Ribe
scott_r...@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Yeah, I was kind of thinking that PG detects the semaphore not existing, bails
immediately, restarts clean, thus no problem. I just wanted to hear from
people, like you, that know way more than I do about the internals.
> On Aug 31, 2017, at 9:08 PM, Tom Lane wrote:
>
> scott rib
Thanks to a typo, I did not turn off systemd's RemoveIPC, and had many many pg
restarts before I figured out the problem.
Should my data be OK? Or do I need to dump & reload?
--
Scott Ribe
scott_r...@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-general mailing list (pgsq
worth adding some explanatory text?
It was really annoying to suddenly start getting this message when I never had
any intention of "running" the JDBC driver ;-)
--
Scott Ribe
scott_r...@killerybtes.com
(303) 722-0567
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
Is it reasonable to run PG on a mirrored pair of something like the Intel SSD
DC 3610 series? (For example:
http://ark.intel.com/products/82935/Intel-SSD-DC-S3610-Series-480GB-2_5in-SATA-6Gbs-20nm-MLC)
I'd *hope* that anything Intel classifies as a "Data Center SSD" would be
reasonably reliable
n the other. I've asked
the other guy to try it in a newly-created database.
> That's a bug. Will fix it.
OK, cool.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-gener
array
LINE 1: select (ARRAY[])::text[];
^
HINT: Explicitly cast to the desired type, for example ARRAY[]::integer[].
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-general maili
)
pedcard=# select (ARRAY[])::text[];
ERROR: cannot determine type of empty array
LINE 1: select (ARRAY[])::text[];
^
HINT: Explicitly cast to the desired type, for example ARRAY[]::integer[].
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
https
Alright, check kernel version, but what else, dump & restore?
ERROR: unexpected data beyond EOF in block 1 of relation base/16388/35954
HINT: This has been seen to occur with buggy kernels; consider updating your
system.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev
tring as needed for this use,
but I found another way based on Tom's suggestion:
execute('insert into ' || tblnm || ' select $1.*') using new;
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
On Apr 2, 2015, at 10:10 PM, Tom Lane wrote:
>
> Not like that, for certain. It might work to use EXECUTE ... USING new.*
> or some variant of that.
Couldn't get a variant of that to work, but this did:
execute('insert into ' || tblnm || ' select $1.*')
Easier to give an example than describe the question, any chance of making
something like this work?
execute('insert into ' || tblname || ' values(new.*)');
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
queries not inside a copy, iow the delete from commands, work.)
Is there any alternative to just duplicating the now() expression inside every
copy?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
S
comprehensive source of current
advice.
(I want to do a prophylactic dump/restore, after a middle-of-the-day OS crash
caused by a third-party in-kernel driver--which I am going to remove now.)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
What checksum algorithm wound up in 9.3?
(I found Simon Riggs 12/2011 submittal using Fletcher's, Michael Paquier's
7/2013 post stating CRC32 reduced to 16, and another post online claiming that
it was changed from CRC before release but not stating what it was changed to.)
--
Thank you all. Both the double index & pg_trgm would be good solutions.
On Oct 14, 2013, at 3:40 PM, Merlin Moncure wrote:
> On Sat, Oct 12, 2013 at 4:28 PM, Torsten Förtsch
> wrote:
>> On 12/10/13 20:08, Scott Ribe wrote:
>>> select * from test where tz >= star
n, but it most certainly is possible.)
Besides, you've given me the hint, if I really care about this I can try a
covering index ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
= '2013-04-30 06:00:00-05'::timestamp with time zone))
Filter: ((colb)::text ~~ '%foobar%'::text)
Rows Removed by Filter: 261725
Total runtime: 230.689 ms
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsq
On Sep 25, 2013, at 6:13 PM, Michael Paquier wrote:
> "SELECT pg_is_in_recovery();" can be used to make the difference
> between a master and a slave.
Exactly what I need; thanks.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
check for the presence of wal sender process vs wal
receiver process? Or is there a query that could executed against sys tables to
find current running config of the local postmaster?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via
On Jun 10, 2013, at 12:52 PM, Tom Lane wrote:
> Scott Ribe writes:
>> pg 9.2:
>> delete from "ExternalDocument" where id = 11825657and "Billed" = 'f';
>
> "11825657and" is not any more lexically ambiguous than "11825657+".
pg 9.2:
delete from "ExternalDocument" where id = 11825657and "Billed" = 'f';
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
but rarely 2 or 3 for a second. The current situation of
lots of entries in it has to do with 1-time processing of legacy data.)
If that can't be what's happening, then I would want to investigate further why
an update of a smallish row with 3 small indexes sometimes takes 600ms.
;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
estore functionality. Prior to this I've always used pg_dumpall.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
es.dump postgres
pg_restore -j 4 -veC -d postgres db.dump
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpre
essage::text) <> ''::text)
"page_log_pager_num_check" CHECK (btrim(pager_num::text) <> ''::text)
Foreign-key constraints:
"page_log_request__id_fkey" FOREIGN KEY (request__id) REFERENCES
page_requests(id)
"page_log_user__id_
t's exactly the kind of thing I was hoping for. I'm actually inserting into
an empty table, so "dead" tuples would be dead accurate in my case ;-)
Or I could suck it up and do them in batches instead of one giant pass...
--
Scott Ribe
scott_r...@elevated-dev.com
so explain on the select statement shows
a bit better than 50% reduction in predicted work for that part. And I will go
ahead and drop all indexes on the target table.)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-g
On Oct 21, 2012, at 11:01 AM, Pavel Stehule wrote:
> Hello
>
> 2012/10/21 Scott Ribe :
>> Briefly, what would it take to make the following work?
>>
>> create function getbatch (variadic ids int8[]) returns setof foobar as $$
>> begin
>>retur
Briefly, what would it take to make the following work?
create function getbatch (variadic ids int8[]) returns setof foobar as $$
begin
return query
select * from foobar where id in (ids);
end;
$$ language plpgsql;
--
Scott Ribe
scott_r...@elevated-dev.com
http
already know about lots & lots of options ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
If you install the latest ARD update (which does not require a reboot), it
apparently does something similar to:
sudo killall postmaster
Oops. Thanks, Apple.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing
As part of anonymizing some data, I want to do something like:
update foo set bar = (select bar2 from fakes order by random() limit 1);
But of course, that sets them all to the same value, whereas I want them all
different.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com
; best
practice, which is, ahem, different than with MySQL.)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. But it took someone pointing it
out to me to get me to notice that irregularity. Fatigue... One more day of
super-crunch and then I get to take a break...
Thanks.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailin
x query
involving 3-way union of 5-way joins--intended for end-user querying.
Of note, this query works (and performance is good enough as well):
select "ICD9", count(*) from (select distinct "Person_Id", "ICD9" from
"PatientDiagnoses") as t0 group by "I
On Oct 11, 2011, at 8:18 PM, The Great SunWuKung wrote:
> This shop is number 1 at my shop-list!
So why the fuck is your spam title "7"???
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (
will usually pretty explicitly tell you why
the server is quitting on launch. So you might just need to read those wrapper
scripts to see how exactly they invoke postgres.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-gene
e the normal UNIX way:
./configure, make, sudo make install... That's the way I do it, and it works
fine on OS X.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
any actual pg instances running there. What you have is
some kind of wrapper that tries to launch pg. That wrapper is failing to
launch, and either looping, or quitting and being relaunched--depending on how
it is set up, which I have no idea about.
--
Scott Ribe
scott_r...@elevated-dev.com
h
#x27;re on a recent version of OS X, you do this in /etc/sysctl.conf.
Also the /usr/bin/postgres that you seen running is not where macports puts it
and not the one you tried to start a couple of lines earlier, so you have
something already installed on your system that is running a postgre
On Oct 3, 2011, at 10:12 AM, Boszormenyi Zoltan wrote:
> But I would like to know why isn't the type conversion from unlimited varchar
> to varchar(255) invoked in the pl/pgsql function?
What if t1 || t2 is longer than 255? You need to explicitly specify.
--
Scott Ribe
scott_r.
n that path, you should seriously
consider whether you really need that, rather than a higher-level solution.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
ers as strings???
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sep 17, 2011, at 1:09 AM, Raghavendra wrote:
> However, I was curious to know any thing stored at Page-Level(like XID) to
> help me in getting the transaction timestamp.
No, there is no such thing. If you want timestamps, you have to record them
yourself.
--
Scott Ribe
scott_r...@el
oat8(3)
1.0/3
1/3.0
1::float8 / 3
...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to produce the corrected query.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sep 1, 2011, at 9:04 AM, Bob Pawley wrote:
> Would it be possible for you to point me to an example??
The EXECUTE command is what you want.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-gene
, so you can't even use all of what's left.
So no, you can't manipulate 32M of anything except plain numbers or very simple
structs in RAM in a 32-bit process.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-gener
k of enabled/disabled elsewhere, so you really need to use
launchctl instead of editing the plist.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On Aug 31, 2011, at 9:51 AM, Don wrote:
> Both machines are 64bit.
Are all your server & client builds 64-bit?
32M rows, unless the rows are <50 bytes each, you'll never be able to
manipulate that selection in memory with a 32-bit app.
--
Scott Ribe
scott_r...@elevat
On Aug 30, 2011, at 8:22 AM, Dan Scott wrote:
> Perhaps because I'm locking the table with my query?
Do you mean you're explicitly locking the table? If so, why???
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via
re are you? You are issuing a command to the server
to create a file at that path on the server.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
words, this is a bug in your clients, and
no, you really would not want PG automatically terminating connections
mid-transaction just because it thought the client was taking too long to get
to the next step.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voi
succeed.
That DDL is also kind of nasty... Why the big effort to set the sequence to 1
immediately after creating the table? Why the creation of a unique index when
the "primary key" attribute already causes a unique index to be created on the
id? Ugh.
--
Scott Ribe
scott_r...@el
Mods: FYI, this is not a one-off thing. I've seen this email on 4 other lists
so far this morning. So some turd is spamming every list he can subscribe to.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing
se may be
something else, but either way I doubt it's a problem with NOTIFY/LISTEN.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Aug 17, 2011, at 12:53 AM, Sim Zacks wrote:
> In your scenario, if you send the NOTIFY message and then you roll back the
> transaction, the helper application will still send the email.
How? NOTIFY doesn't get delivered until the transaction commits.
--
Scott Ribe
scott_r.
1-21','Potassium','0.94988','mg/L','','','','...
> ^
> The column is NULLable and if there's no value a NULL should be entered.
An empty string is not null.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www
> After open source for the software, we will wait for open resource for the
> hardware (this is just a first example http://www.arduino.cc/, even if of
> different nature).
While the plans may be free, the actual hardware sure as hell won't be.
--
Scott Ribe
scott_r...@elevate
oblems.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t and the other is 64-bit, or one machine is
big-endian and the other is little-endian...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
amp; ABc are all equal, so any
order for those 3 would be correct...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ould include information about
supported platforms. Any announcement submitted without that info should be
rejected, and the vendor instructed to add it before re-submission.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-gener
On Jul 19, 2011, at 9:27 AM, Martin Gainty wrote:
> I do'nt believe Rao would discriminate against anyone that speaks the Kings
> English.
So, what makes you think they won't hire us Americans?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303
re going to
get on a Postgres mailing list ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing on the server so you can see what the actual CREATE TABLE
> command sent to the server looks like.
That's it. Rake is part of Ruby on Rails, and RoR wants every table to start
with an integer synthetic key column.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com
correct calculations...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rds
>> with subjective meaning.
>>
>> I'd like in ask the pgsql community for suggestions on how they name tables.
Well, when I avoid camel case, then I use _ to separate words in a table name,
and __ to separate table names.
Likewise with column names for foreign keys
r is, I
think, not useful.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jun 20, 2011, at 1:32 PM, Leon Match wrote:
> How can I insert a dynamic timestamp value in postgress, please?
< http://www.postgresql.org/docs/9.0/static/functions-datetime.html>
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
On Jun 19, 2011, at 12:33 AM, David Boreham wrote:
> One thing I don't understand is why is the BBU option never available with
> "integrated" LSI controllers?
Because "integrated" means it's on the mobo to save costs.
--
Scott Ribe
scott_r...@elevated
robably go for safety. (FYI this is not my only margin for failure. Two
geographically-distributed WAL-streaming replicas with low-end RAID1 are the
next line of defense. Followed by, god forbid I should ever have to use them,
daily dumps.)
Thanks for all the info. I guess about all I have rema
her digging, I discover that ATTO ExpressSAS is an option for me.
Anyone got comments on these? (I notice that they use ultracapacitor/flash to
protect cache...)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list
use RAID 5; it's RAID 6 that I'm considering...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
RAID 5 is not generally recommended for good db
performance. But if the database is not huge (10-20GB), and the server has
enough RAM to keep most all of the db cached, and the RAID uses
(battery-backed) write-back cache, is it sill really an issue?
--
Scott Ribe
scott_r...@elevated-dev.com
http:
s.
(But then again, db tools in general aren't really masters of the obvious when
it comes to user interface...)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
to
ask regarding this and/or what brands/buzzwords to look for.
Any and all advice and links appreciated ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
g) subset of the data at the same
time, but now I think I'm really set!
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
; that is slow. Generally, the
> system table is good enough for that, I find. (Someone: "How long
> will this take?" Me: "There are about 400 million rows to go
> through." Even if you're off by 50 million at that point, it doesn't
> matter.)
FYI, I ha
ated total rows in a table, nothing useful for this.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mples--more if we've been around for a while. Original design cutting
corners on power regulation; final manufacturers cutting corners on specs;
component manufacturers cutting corners on specs or selling outright
counterfeit parts...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.ele
many others I've read about are not in high-write db workloads, so they're
not write wear, they're just crappy electronics failing.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-gener
On May 4, 2011, at 10:50 AM, Greg Smith wrote:
> Your link didn't show up on this.
Sigh... Step 2: paste link in ;-)
<http://www.codinghorror.com/blog/2011/05/the-hot-crazy-solid-state-drive-scale.html>
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
Yeah, on that subject, anybody else see this:
<>
Absolutely pathetic.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
The
scheme, which had been stable for 20+ years, had to change when a new variant
of product was introduced which cut across family & product. I don't remember
the details. I do remember that I hadn't used the supposedly stable product ids
as PKs ;-)
--
Scott Ribe
scott_r
n't really exist. What's usually proposed as a
natural key, will upon further investigation, either not be guaranteed unique,
or not guaranteed to be unchanging, or both.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-g
study of large numbers of disks in data
centers, and the result was that actual lifespans were so far from MBTF specs,
that the remaining disks would have to just about outlive the universe in order
to get the mean near the same order of magnitude as the published numbers.
--
Scott Ribe
scott_
y a very healthy skepticism factor.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Apr 21, 2011, at 9:44 AM, Florian Weimer wrote:
> But log files are recycled, so looking at the directory alone does not
> seem particularly helpful.
You have to look at the file timestamps. From that you can get an idea of
traffic.
--
Scott Ribe
scott_r...@elevated-dev.co
On Apr 6, 2011, at 9:47 AM, Davenport, Julie wrote:
> We’ve never explicitly closed the connection, it just seemed to close
> automatically when the coldfusion script ended.
My guess is you've also upgraded coldfusion, or changed its config, and now
it's caching connections.
sql.org/docs/9.0/static/trigger-definition.html>
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t; due to which the behavior is not uniform?
While I do have a couple of ideas, you're probably better served by letting
those here with more optimization experience help you, as their answers will be
more complete.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
ter a reboot, or various command-line tricks to purge cache) vs
against warm caches (twice back-to-back).
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
constraints to be created without specifying that column. And some
ORM/apps/frameworks can automatically make use of the information as well. I
like having them for clarity, but you really can do away with them if your
deployment needs to do so.
--
Scott Ribe
scott_r...@elevated-dev.com
http:/
On Mar 8, 2011, at 7:54 AM, James B. Byrne wrote:
> My question is: Why am I getting a NULL exception?
Because you're trying to insert NULL explicitly?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mail
On Mar 2, 2011, at 11:43 AM, Michael Black wrote:
> Thanks Scott. I just did not see the options in the PGAdmin III nor in the
> doc at
You may want to bookmark this:
<http://www.postgresql.org/docs/9.0/static/sql-commands.html>
--
Scott Ribe
scott_r...@elevated-dev.com
http://
other SQL database: create index foobaridx on foo(bar)...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
fy what time zone I’m talking
> about, I got the correct answer.
You didn't specify the time zone, so it used your local time zone info--but not
just your current offset from UTC, rather the offsets from UTC at the
dates/times specified.
--
Scott Ribe
scott_r...@elevated-dev.com
htt
1 - 100 of 394 matches
Mail list logo
