Greg Smith 2ndquadrant.com> writes:
> You're probably running into this problem:
> http://notemagnet.blogspot.com/2008/05/pgbench-suffering-with-linux-2623-2626.html
You are so right. The last thing I would have suspected is a kernel bug. I am
definitely going to try to be more aware of kernel
I have deployed PostgresSQL 8.4.1 on a Fedora 9 c1.xlarge (8x1 cores) instance
in the Amazon E2 Cloud. When I run pgbench in read-only mode (-S) on a small
database, I am unable to peg the CPUs no matter how many clients I throw at it.
In fact, the CPU utilization never drops below 60% idle. I also
Jim Mlodgenski gmail.com> writes:
> I have seen behavior like this in the past on EC2. I believe your bottleneck
may be pulling the data out of cache. I benchmarked this a while back and found
that memory speeds are not much faster than disk speeds on EC2. I am not sure if
that is true of Xen in g
John R Pierce hogranch.com> writes:
> more likely, he's disk IO bound, but hard to say as that iostat output
> only showed a couple 2 second slices of work. the first output, which
> shows average since system startup, seems to show the system has had
> relatively high average wait times of 1
> Could you try this again with "top -c", which will label these
> postmaster processes usefully, and include the pgbench client itself in
> what you post? It's hard to sort out what's going on in these
> situations without that style of breakdown.
I had run pgbench on a separate instance last
Greg Smith 2ndquadrant.com> writes:
> Could you try this again with "top -c", which will label these
> postmaster processes usefully, and include the pgbench client itself in
> what you post? It's hard to sort out what's going on in these
> situations without that style of breakdown.
As a fur
Jim Mlodgenski gmail.com> writes:
> Let's start from the beginning. Have you tuned your postgresql.conf file? What
do you have shared_buffers set to? That would have the biggest effect on a test
like this.
shared_buffers = 128MB
maintenance_work_mem = 256MB
checkpoint_segments = 20
--
Sent v
Greg Smith 2ndquadrant.com> writes:
> Looks to me like you're running into a general memory bandwidth issue
> here, possibly one that's made a bit worse by how pgbench works. It's a
> somewhat funky workload Linux systems aren't always happy with, although
> one of your tests had the right co
In an attempt to determine whether top(1) is lying about the CPU utilization, I
did an experiment. I fired up a EC2 c1.xlarge instance and ran pgbench and a
tight loop in parallel.
-bash-4.0$ uname -a
Linux domu-12-31-39-00-8d-71.compute-1.internal 2.6.31-302-ec2 #7-Ubuntu SMP Tue
Oct 13 19:55:22
few of the tables that don't store editor, in which case I
am ok with inserting it into the log as NULL. The problem is I can't
seem to come up with a conditional to see if NEW has a column named
"editor".
Any help is greatly appreciated.
Thanks.
Mike Ginsburg
--
Sent
Merlin Moncure wrote:
On Thu, Feb 4, 2010 at 11:41 AM, Mike Ginsburg
wrote:
I have a plpgsql function that serves as a change log for a few tables in my
db (8.4.2). In most of the tables that I am logging, there is an "editor"
column that stores the ID of the user who made the
n
Thanks again for all the help. I started playing around with custom
session vars and it seems to be working well.
Mike Ginsburg
mginsb...@collaborativefusion.com
Hello All,
Has anyone got a working program that reads a tuple from a table (defined
as a single Composite type with "lower" atributes also as composite types) and
converts the data into the corresponding C structure variables ?
I've been looking for a working example, but havn´t found that s
I have a problem compiling pgc programs with ecpg.
I always get the following error:
/usr/local/pgsql/lib/libpgtypes.a(timestamp.o): In function `timestamp2tm':
timestamp.c:(.text+0x2fc): undefined reference to `rint'
Version: PostgreSQL 8.3.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.4
Hello all, I get the following error message when ecpg precompiles an EXEC SQL
INCLUDE on this variable:
short cst_vent[MAX_SUC][12]; (MAX_SUC is defined as 24)
Mesage:
"No multidimensional array support for simple data types"
Is there a fix or am I stuck?
Version: PostgreSQL 8.
Geospatial data, but it's usually cities, stations, etc.,
not a regular grid that doesn't change...
I also noticed that PostGIS does not support raster data...
Thanks a lot,
--
Mike
as hours
FROM (SELECT '3 day 2 hour 34 minute'::interval) AS foo;
This seem like a bad hack, and I can't believe a function doesn't
already exist to properly cast a time interval to a fractional unit of
time, so I thought I'd check up to see if there is a better solution.
On 30 March 2010 11:55, Tom Lane wrote:
> I think what Mike is actually looking for is
>
> SELECT extract(epoch from interval '3 days 2 hours 34 minutes');
> date_part
> ---
> 268440
Yet better, if I define 1 hour as 3600 seconds (this is only incorrect
Hello all, this is not a joke. Does anyione know if PgCluster as a project is
suspended, or is alive and kicking. In the second case, has anyone got a medium
sized system working well with this multi-master replication option.?
Hope to hear soon.
Mike Stanton Santiago, Chile
n't know what to do with this. I want to end up with an int[] array.
Can anyone suggest something?
Thanks a lot,
--
Mike
data?
______
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
mike.blackw...@rrd.com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* *
http://www.postgresql.org/docs/9.1/static/functions-subquery.html
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office
The manual section on the postmaster process has some info:
http://www.postgresql.org/docs/current/static/app-postgres.html
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR
em,
rather than have using up time/disk for backup. Might there be a way to
tag those databases somehow so the backup script knows to skip them? I'd
rather not hard code the list in the script.
Thoughts?
__
missed a
'user-defined database level metadata' field somewhere. ^_^
Thanks,
______
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, I
hange.
I have use the system catalogs for several one time projects related to
foreign keys, including checking which fks have associated indexes defined.
______
*Mike Blackwell | Technical Analyst, Distribution Services/Ro
I have a table with this layout:
CREATE TABLE Favorites
(
FavoriteId uuid NOT NULL, --Primary key
UserId uuid NOT NULL,
RecipeId uuid NOT NULL,
MenuId uuid
)
I want to create a unique constraint similar to this:
ALTER TABLE Favorites ADD CONSTRAINT Favorit
On Sun, Nov 27, 2011 at 1:47 PM, Thomas Kellerer wrote:
> Mike Christensen wrote on 27.11.2011 22:18:
>>
>> I have a table with this layout:
>>
>> CREATE TABLE Favorites
>> (
>> FavoriteId uuid NOT NULL, --Primary key
>> UserId u
On Sun, Nov 27, 2011 at 2:18 PM, David Johnston wrote:
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen
> Sent: Sunday, November 27, 2011 5:02 PM
> To: Thomas Kellerer
>
'rad38351.bat'...
Executing batch file 'rad38351.bat'...
Reading:objConfFile is nothing...
Writing:objConfFile is nothing...
We’ve also tried with 8.3 and 9.1 installers and get exactly the same
result.
Any help of hints would be most appreciated.
Regards,
Mike Wylde
I have a database full of recipes, one recipe per row. I need to
store a bunch of arbitrary "flags" for each recipe to mark various
properties such as Gluton-Free, No meat, No Red Meat, No Pork, No
Animals, Quick, Easy, Low Fat, Low Sugar, Low Calorie, Low Sodium and
Low Carb. Users need to be ab
bably favour hstore over it.
The hstore module sounds fantastic!
I'm curious as to how these columns are serialized back through the
driver, such as Npgsql. Do I get the values as strings, such as a
comma delimited key/value pair list? Or would I need to do some
custom logic to deserialize them?
Right now, I'm using Npgsql as a driver, and NHibernate/Castle
ActiveRecord as an ORM.
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to make sure I don't need an operator on the WHERE clause. Thanks!
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-is-this-the-right-way-to-create-a-partial-index-on-a-boolean-column
I'm 90% sure this is the right way to do it though.
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Dec 14, 2011 at 9:54 PM, Mike Christensen wrote:
>> For the boolean column Foo in Table1, if I want to index all values of
>> TRUE, is this syntax correct?
>>
>> CREATE INDEX IDX_MyIndex ON Table1(Foo) WHERE Foo;
>>
>> The query:
>>
>> SELE
On Thu, Dec 15, 2011 at 6:00 AM, Craig Ringer wrote:
> On 12/15/2011 03:53 PM, Alban Hertroys wrote:
>>
>> Correct, but...
>> That's not a particularly useful index to create. That index just contains
>> values of true where the associated column equals true - you're storing the
>> same informatio
I'd like to temporarily disable autovacuum on a single database while it is
being loaded. Is there an easy way to do this?
______
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management
#x27;t stop
the applications/users attempting to access the database, to avoid them
grabbing another connection while I'm typing.
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnell
and
you have to use System.Convert().
Is there a work-around, or do people just cast or use Int16 in their
data structures? Just wondering.. I know on modern computers it
probably doesn't make any difference anyway..
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
>> According to the manuals, Postgres has smallint (2 byte), integer (4
>> bytes) and bigint (8 bytes).. I use a lot of structures with "bytes"
>> in my code and it's kinda annoying to cast DB output from Int16 to
>> Byte every time, especially since there's no explicit cast in .NET and
>> you hav
My guess is that there's some non-trivial cost to
> maintaining each core type, and since a byte type isn't required by
> the SQL spec, it would take some effort to get a standard one included
> in the core.
That makes sense.
I guess my question is more of a NpgSql question then. Is there a way
to create a custom PG type, and have npgsql serialize that type in a
dataset to a .NET Byte type?
I'd probably be better off posting on the npgsql mailing list, but
perhaps someone here knows as well..
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sun, Jan 8, 2012 at 10:12 AM, Francisco Figueiredo Jr.
wrote:
> On Sun, Jan 8, 2012 at 06:54, Mike Christensen wrote:
>>>>>>> According to the manuals, Postgres has smallint (2 byte), integer (4
>>>>>>> bytes) and bigint (8 bytes).. I use a lot
tandard one included
>>>>> in the core.
>>>>
>>>> That makes sense.
>>>>
>>>> I guess my question is more of a NpgSql question then. Is there a way
>>>> to create a custom PG type, and have npgsql serialize that type in a
sable nature allows you to build your
>>>>>>> own types as well. If it's popular enough it'll make it into contrib,
>>>>>>> then maybe core. My guess is that there's some non-trivial cost to
>>>>>>> maintaining each core typ
econd table? However, I have no idea what
the syntax would be like.
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> 2012/1/11 Mike Christensen :
>> I would like to write a function that returns one row from one table,
>> and about 10 rows or so from another table..
>>
>> Is there a clean way to do this, or am I better off making two separate
>> queries?
>>
>> I&
The following are the relevant log entries from a recent crash of v9.1.1
running on an older RHEL Linux box. This is the first crash we've
experienced in a lot of years of running Pg. Any assistance in how to
determine what might have caused this is welcome.
--
2012-02-10 13:55:59 CST [15949]:
is portable
> across different DBMSs, even better :)
>
>
For PostgreSQL only, see
http://www.postgresql.org/docs/9.1/interactive/functions-info.html for a
list of functions for this.
Mike
p_order_ids" in database "mydb"
2012-02-27 13:05:35 CST [18400]: [2-1] @ LOCATION: do_autovacuum,
autovacuum.c:2022
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Do
feeling is to reduce shared_buffer to 1GB or less and reduce
connections to ~150-200 (to reduce worst case work_mem impact).
Kind Regards,
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Mar 5, 2012 at 4:04 PM, Tom Lane wrote:
> Mike C writes:
>> I have been using table 17-2, Postgres Shared Memory Usage
>> (http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html)
>> to calculate approximately how much memory the server will use. I'
: cannot alter table "a" because column "a_audit.new_record" uses
its row type
A solution that doesn't lose the existing data is preferable.
Mike
>
>
> works for me -- what version are you on?
>
> merlin
>
> --
>
> [wcs1459@aclnx-cisp01 ~]$ psql --version
> psql (PostgreSQL) 9.1.1
> contains support for command-line editing
>
>
> [wcs1459@aclnx-cisp01 ~]$ cat x
> create table a (
> id serial,
> stuff text,
> more_stuff text
> );
>
Not a bad idea. I'd need to convert existing data, but it'd be an excuse
to try out hstore. ^_^
Mike
* *
On Thu, Mar 8, 2012 at 11:08, Merlin Moncure wrote:
> On Wed, Mar 7, 2012 at 2:49 PM, Merlin Moncure wrote:
> > On a practical level, the error blocks nothing -
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
mike.blackw...@rrd.com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* *
On Wed, Mar 14, 2012 at 16:04, Ale
On Mon, Mar 19, 2012 at 11:16 AM, Ben Chobot wrote:
> On Mar 19, 2012, at 10:59 AM, Welty, Richard wrote:
>
> i just finished this thread from May of last year, and am wondering if this
> still represents consensus thinking about postgresql deployments in the EC2
> cloud:
>
> http://postgresql.104
> On Mon 3/19/2012 4:30 PM Mike Christensen writes:
>
>>I've been running my site on RackSpace CloudServers (similar to EC2)
>>and have been getting pretty good performance, though I don't have
>>huge amounts of database load.
>
>>One advantage, though,
I'd like to switch to PITR backups, but have limited disk space. Is there
a way to get a ballpark estimate by monitoring a running system, without
actually creating the WAL files and risking filling a filesystem?
Mike
Hey Everyone,
I've got an interesting issue. We're running postgres 9.1.1 linux x64
centos 5.8
aspdata=# select version();
version
--
This query returns 9843923 rows from the DB. So processing this seems like
it'll take quite a while.
I'll get a -pg build of pg_dump going here on a dev box so I can get you a
profile.
On Fri, Mar 30, 2012 at 10:18 AM, Tom Lane wrote:
> Mike Roest writes:
> > This dump is c
on my
dev box then ran it on the server. I'm just running the actual dump on my
dev box against the server instead to see if I get something more useful
since that doesn't really seem to have much data in it)
On Fri, Mar 30, 2012 at 11:09 AM, Mike Roest wrote:
> Here's the gmon.o
That was on the CentOS 5.8 x64 machine. The one I'm trying it from now is
Ubuntu 11.10 x64
On Fri, Mar 30, 2012 at 11:30 AM, Tom Lane wrote:
> Mike Roest writes:
> > Ok I just realized that's probably not going to be much help :)
>
> gmon.out would be of no val
>
> That could be out-of-date info though. Here's some info about
> another possibility:
> http://wiki.postgresql.org/wiki/Profiling_with_perf
>
>
There we go this perf worked on the VM.
The file is 6 megs so I've dropped it here.
That was doing perf for the length of the pg_dump command and the
your previous question about sequences there are 61K in the
DB, looks like our schema currently has about 115 sequences per tenant.
--Mike
>
>
> I'm just pulling another backup using the stock 9.1.1 pg_dump to ensure
> the backups are equivalent.
>
> Schema & data are identical between the 2 backups. the new backup passes
all our tests for validating a tenant.
Thank you again for the quick response!
--Mike
:) yah that makes sense no big deal. i'll probably just push this head
buiild of pg_dump onto the production machines till it comes out.
Thanks again!
On Sat, Mar 31, 2012 at 3:44 PM, Tom Lane wrote:
> Mike Roest writes:
> > Any idea when 9.1.4 with this change will be out
Could someone please explain to me why the following select does not
result in a syntax error? (9.0.3)
begin;
create table x( c1 integer , c2 integer);
create table y( c3 integer, c4 integer);
select * from x where c2 in ( select c2 from y where c4 = 2 );
rollback;
Mike
--
Sent via pgsql
Indeed.
__
Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
mike.blackw...@rrd.com
http://www.rrdonnelley.com
Indexer INSERT
permissions:
GRANT INSERT ON Indexer.ParseErrors TO "Indexer";
Then everything works.
Am I missing something? Doesn't GRANT ALL mean that user can do
anything they want with objects in that schema, including inserts?
Thanks!
Mike
--
Sent via pgsql-general mailing list
Excellent, thanks so much!
Mike
On Thu, May 10, 2012 at 9:38 PM, Christophe Pettus wrote:
>
> On May 10, 2012, at 9:16 PM, Mike Christensen wrote:
>> Am I missing something? Doesn't GRANT ALL mean that user can do
>> anything they want with objects in that schema, includ
though) and there's no dblink.sql file anywhere to be found, nor does
the dblink() function exist in any schema out of the box. Is there
somewhere to download the installation script, or is there another
method to install this support? Thanks!
Mike
--
Sent via pgsql-general ma
I just installed Ubuntu 12.04 today. Postgres was not listed in the
Ubuntu Software Center, so I downloaded the apt installer from:
http://www.openscg.com/se/oscg_home_download.jsp
Mike
On Mon, May 14, 2012 at 6:10 PM, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Mon, 2012-05-14 at 18:05 -0
I often manually pull in production data into my test database so I
can test new code on realistic data, as well as test upgrade scenarios
or repro data specific bugs. To do this, I've setup a `VIEW` for each
production table in my test database. These views look something like
this:
CREATE
Thanks!
I've never done that in PG before, but I've used named connections
with Oracle. Is it the same sort of deal? There's a file on the disk
somewhere with the connection info? Either way, I'm sure it's a RTFM
thing so I'll look into it.
Mike
On Tue, Ma
account for that
difference on the INSERT line, such as:
INSERT INTO Recipes SELECT *, false as SomeNewColumn FROM
ProdLink.Recipes WHERE ...
So, this may or may not work. Still, good to know!
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is something
>> that could be stored in pg_*.conf or as an environment variable?
>
> yes, they are called 'tables' :-). stick your connection string in a
> table somewhere and do:
>
> create view v as
> select (u).* from dblink((select connstr from yadda where yadda), ...);
That's definitely an approach. I think I know the possible options
anyway. I just wanted to make sure there wasn't anything I was
missing. Thanks for your help!
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ment =
warning. This is 9.1.3 These are two separate databases running on the
same server (postgresql instance).
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wall
tion field which contains the
length of the call in seconds.
I need to find out how many concurrent calls I supported, at peek
volume.
Can this be done in SQL? Or do I need to write a perl script?
Thank you,
Mike.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
quot;#"
LINE 3: INTO #ratings
^
** Error **
ERROR: syntax error at or near "#"
SQL state: 42601
Character: 53
Perhaps there's a different way to create temp tables? Even better is
if someone can re-write the query to not use the temp table, I'm far
from a SQL exp
FROM RecipeRatings GROUP BY
RecipeId;
UPDATE Recipes
SET Rating = tr.Rating
FROM temp_ratings as tr
WHERE Recipes.RecipeId = tr.RecipeId AND Recipes.Rating <> tr.Rating
Mike Christensen wrote:
Hi guys, I'm in the process of migrating my database from MS SQL 2005
to PostgreSQL and
this, but I think this query will end up
locking every row in the recipes table which could be tens of thousands,
and create some perf issues or deadlocks. Even though I run this query
once per day to update ratings, I'd like to keep it as streamlined as
possible..
Mike
Tino Wildenhain
;max table size" before you have to
allocate more space on the disk, however I can't seem to find where
these settings are and how to allow millions of rows to be inserted into
a table without having to vacuum every few million rows..
Mike
--
Sent via pgsql-general mailing list (pgs
I have well over 50 gigs free on that drive.. I doubt it.
Scott Marlowe wrote:
On Wed, Feb 18, 2009 at 1:39 PM, Mike Christensen wrote:
Hi all -
ERROR: could not extend relation 1663/41130/41177: No space left on device
HINT: Check free disk space.
You're running out of
is Windows
Server 2003 SBS, I'm not an expert
Bill Moran wrote:
In response to Mike Christensen :
I have well over 50 gigs free on that drive.. I doubt it.
I'm not aware of that error having false-positives associated with it.
Common confusion on this point could resul
5 GMT HINT: Is another postmaster (PID 1888) running
in data directory "C:/Program Files/PostgreSQL/8.3/data"?
After I delete the file, I try to start the service again and get:
2009-02-18 13:27:18 PST FATAL: could not create any TCP/IP sockets
Any ideas?
John R Pierce wrote:
Mi
t a few seconds and retry.
2009-02-18 14:02:51 PST WARNING: could not create listen socket for "*"
2009-02-18 14:02:51 PST FATAL: could not create any TCP/IP sockets
Timed out waiting for server startup
I'm totally out of ideas, anyone know how to fix this? Thanks!
Mike
--
Se
dir/plugins/plugin_debugger.dl
l"
2009-02-18 14:23:53 PST DEBUG: invoking IpcMemoryCreate(size=38395904)
2009-02-18 14:23:53 PST DEBUG: max_safe_fds = 987, usable_fds = 1000,
already_o
pen = 3
Mike Christensen wrote:
Hi All -
I'm having problems getting the PostgreSQL service
stion, if I just re-install postgres and create a fresh new
instance, is there a way to import my old data files back into the
database? Thanks!
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
;
If I skip over it, it continues but then gets other errors due to bad
file handles.. Heh, whatever I did totally wrecked the DB.. We really
need some sort of dbrepair tool one of these days..
Mike
Joshua D. Drake wrote:
On Wed, 2009-02-18 at 19:58 -0800, Mike Christensen wrote:
I have
AL: index "41330" contains unexpected zero
page at b
lock 0
2009-02-19 00:02:05 PST HINT: Please REINDEX it.
The process just quits if it can't repair the DB. How can I tell it not
to try to repair this database and just let me access the other DBs?
Thanks!
Mike
Joshu
bout
five months of work gone. I have a little tool that dumps my DB to an
XML file (the only file format I really trust), and I'm gonna configure
that to run nightly. Thanks for all the help guys!
Mike
Mike Christensen wrote:
After looking at it more, it seems the problem is it's
state where it wouldn't boot
anymore. I was eventually able to fix it by resetting the transaction
log manually. I'm hoping future versions of Postgres will handle this
scenario a lot better..
Mike
Grzegorz Jaśkiewicz wrote:
I bet it is on windows (judging by html in that email
amiliar with some of the source code and debugging,
and it's made me finally get around to writing an automatic backup
script that runs every midnight.
Mike
Scott Marlowe wrote:
On Thu, Feb 19, 2009 at 3:11 AM, Mike Christensen wrote:
Actually I'm writing emails on my Mac
However
Yea sorry good point.. It's probably at least safe to say the process
should not just hang though, and there should be more info in the log as
to what it's doing..
John R Pierce wrote:
Mike Christensen wrote:
First off, when Postgres starts and sees that your database was n
mething? Is there a better
way to query rows by date? Thanks!
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'd tell you, but I lost the database last night
I'll go rebuild the test data but it'll take a while.
Scott Marlowe wrote:
On Thu, Feb 19, 2009 at 9:32 PM, Mike Christensen wrote:
Hi all -
I have a fairly simple query:
select * from subscriptions s
inner join not
exed (dunno if this is true or
not)..
Any other ideas would be appreciated.. Thanks!
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
_time
from tbl f
where f.username = ANY ($1);
$_$
LANGUAGE sql SECURITY DEFINER;
On Fri, Feb 20, 2009 at 8:50 AM, Mike Christensen <mailto:ima...@comcast.net>> wrote:
I have the following function:
CREATE FUNCTION foo(_userid uuid)
RETURNS SETOF recor
l, it just figures out the
composite type is a DataRow.
Sweet!
Mike
Asko Oja wrote:
CREATE FUNCTION func(
i_users text[],
OUT username text,
OUT update_time timestamp with time zone
) RETURNS SETOF record AS
$_$
select f.username , f.update_time
from tbl f
wrote:
Mike Christensen wrote:
I have the following function:
CREATE FUNCTION foo(_userid uuid)
RETURNS SETOF record AS
$BODY$
BEGIN
RETURN QUERY
select n.UserId, u.Alias, n.Date, n.Data
--Bunch of joins, etc
If I understand correctly, I have to return "SETOF record" since
501 - 600 of 1197 matches
Mail list logo
